. NET Connect to Oracle Methods

. NET Connect to Oracle Methods

Mode 1: Direct use. NET Oracle-driven connectivity

Reference System.data.oracleclient;

Using System.data.oracleclient;

String oradb = "Data source=water; User Id=modis; Password=modis;integrated Security=no ";

OracleConnection conn = new OracleConnection (ORADB);

Conn. Open ();

Mode 2: Odp.net (Oracle Data provider.net) is installed and connected via OLE DB.

Reference System.Data.OleDb;

Using System.Data.OleDb;

String oradb = "Provider=oraoledb.oracle;data source=water; User Id=modis; Password=modis; ";

OleDbConnection myconnection = new OleDbConnection (ORADB);

Myconnection.open ();

Mode 3: After installing Odp.net, through the Oracle Connector

Reference the dynamic link library Oracle.DataAccess.Client.

Using Oracle.DataAccess.Client;

String oradb = "Data source=water; User Id=modis; Password=modis; ";

OracleConnection conn = new OracleConnection (ORADB); C#

Conn. Open ();