Oracle Data Provider for .NET / ODP.NET
This .NET Framework Class Library is provided by Oracle.
The main functionality of the class library is contained in the file Oracle.DataAccess.dll.
Add a reference to the assembly Oracle.DataAccess and include the Oracle.DataAccess.Client namespace. Instantiate a new OracleConnection connection object. Set the connection string and open the connection.
VB.NET code sample
Imports Oracle.DataAccess.Client
Dim myConnection As OracleConnection = New OracleConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()C# code sample
using Oracle.DataAccess.Client;
OracleConnection myConnection = new OracleConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();Description
The Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security. The data provider can be used with the latest .NET Framework version.
ODP.NET includes many features not available from other .NET drivers, including a native XML data type, array parameters, RAC optimizations, and statement caching. ODP.NET is designed for scalable enterprise Windows solutions by providing full support for Unicode and local and distributed transactions.
More info about this class library can be found at the Oracle product page.
Download
This .NET Framework Class Library, Oracle Data Provider for .NET / ODP.NET, can be downloaded here.
Connection Strings
The Oracle Data Provider for .NET / ODP.NET class library can be used to connect to the following data sources by using the following connection string references: