Loading ad...

.NET Framework Data Provider for Oracle

This .NET Framework Class Library is provided by Microsoft.
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
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
.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:

Oracle
To see available connection options, navigate connection strings reference by the above data source links.
Additional info or comments on this class library? Want to submit content?

Popular

Copyright © 2013 30c.org   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.