.NET Framework Data Provider for OLE DB
This .NET Framework Wrapper Class Library is provided by Microsoft.
The wrapper class library is contained in the file System.Data.dll.
The wrapper class library is contained in the file System.Data.dll.
Coding
Add a reference to the assembly System.Data and include the System.Data.OleDb namespace. Instantiate a new OleDbConnection connection object. Set the connection string and open the connection.
VB.NET code sample
C# code sample
VB.NET code sample
Imports System.Data.OleDb
Dim myConnection As OleDbConnection = New OleDbConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
Dim myConnection As OleDbConnection = New OleDbConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
C# code sample
using System.Data.OleDb;
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();
Description
The .NET Framework Data Provider for OLE DB uses native OLE DB through COM interop to enable data access. The OleDbConnection wraps/bridges to the underlying data provider specified in the connection string using the keyword "Provider". This means that virtually every OLE DB provider can be used through this class library. The .NET Framework Data Provider for OLE DB supports both local and distributed transactions. For distributed transactions, the .NET Framework Data Provider for OLE DB, by default, automatically enlists in a transaction.
More info about this wrapper class library can be found at the Microsoft product page.
Download link missing
The .NET Framework Data Provider for OLE DB installation package download link is missing. Please provide info and contribute to the community by email to
Connection Strings
Additional info or comments on this wrapper class library? Want to submit content?