.NET Framework Data Provider for Oracle
This is a .NET Framework Class Library provided by Microsoft.
The class library is contained in the file System.Data.OracleClient.dll.
The class library is contained in the file System.Data.OracleClient.dll.
Coding
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
C# code sample
VB.NET code sample
Imports System.Data.OracleClient
Dim myConnection As OracleConnection = New OracleConnection;();
myConnection.ConnectionString = myConnectionString
myConnection.Open()
//execute queries, etc
myConnection.Close()
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();
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.
Connection Strings
Additional info or comments on this class library? Want to submit content?
Send an e-mail to
Send an e-mail to
Selected Articles