.NET Framework Data Provider for Oracle

This .NET Framework Class Library is provided by Microsoft. The main functionality of the class library is contained in the file System.Data.OracleClient.dll.

Add a reference to the assembly System.Data.OracleClient and include the System.Data.OracleClient namespace. Instantiate a new OracleConnection connection object. Set the connection string and open the connection.

VB.NET code sample
Imports System.Data.OracleClient
Dim myConnection As OracleConnection = New OracleConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
C# code sample
using System.Data.OracleClient;
OracleConnection myConnection = new OracleConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();

Description

The .NET Framework Data Provider for Oracle provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. The functionality of the data provider is designed to be similar to that of the .NET Framework data providers for SQL Server, OLE DB, and ODBC.

More info about this class library can be found at the Microsoft product page.

Download

This .NET Framework Class Library, .NET Framework Data Provider for Oracle, can be downloaded here.

Connection Strings

The .NET Framework Data Provider for Oracle class library can be used to connect to the following data sources by using the following connection string references:

Oracle