A.5 The ODP.NET Provider

Oracle also provides its own native provider called ODP.NET (see Table A-8). It can connect to an Oracle 8 i or later database and be downloaded from http://otn.oracle.com/tech/ windows /odpnet with documentation and code samples. The ODP.NET provider provides the standard connection-based and type-specific classes, and is actually quite similar in structure to the Microsoft provider for Oracle.

To use the ODP.NET types, add the reference to the Oracle.DataAccess.dll assembly in your Visual Studio .NET project, or use the following command line when compiling:

 csc /r:Oracle.DataAccess.dll codeFile.cs 
Table A-8. ODP.NET provider classes

Interface

Implementing class

 IDbConnection 
 OraConnection 
 IDbCommand 
 OraCommand 

IDataParameter , IDbDataParameter

 OraParameter 

IDataReader , IDataRecord

 OraDataReader 

IDataAdapter , IDbDataAdapter

 OraDataAdapter 
 IDbTransaction 
 OraTransaction 


ADO. NET in a Nutshell
ADO.NET in a Nutshell
ISBN: 0596003617
EAN: 2147483647
Year: 2005
Pages: 415

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net