System.Data.OleDb 8.0.0

About

This package implements a data provider for OLE DB data sources.

Key Features

Allows access to legacy OLE DB data sources.

How to Use

This is a basic example of retrieving the results of a query using an OleDbDataReader. For examples of using an OleDbDataAdapter, and of updating an OLE DB data source, please see the documentation.

using System.Data.OleDb;

string connectionString = "";
string queryString = "SELECT OrderID, CustomerID FROM Orders";

using OleDbConnection connection = new OleDbConnection(connectionString);
using OleDbCommand command = new OleDbCommand(queryString, connection);

connection.Open();
using OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())
{
    Console.WriteLine(reader.GetInt32(0) + ", " + reader.GetString(1));
}

Main Types

  • OleDbConnection represents an open connection to an OLE DB data source.
  • OleDbCommand represents an SQL statement or stored procedure to execute against an OLE DB data source.
  • OleDbDataReader provides a way of reading a forward-only stream of data rows from an OLE DB data source.
  • OleDbDataAdapter represents a set of data commands and a database connection that are used to fill a DataSet and update the OLE DB data source.

Additional Documentation

System.Data.Odbc is a similar package for accessing ODBC data sources.

Feedback & Contributing

System.Data.OleDb is released as open source under the MIT license. Bug reports are welcome at the GitHub repository. This package is considered complete and we only consider low-risk, high-impact fixes that are necessary to maintain or improve quality.

No packages depend on System.Data.OleDb.

https://go.microsoft.com/fwlink/?LinkID=799421

.NET Framework 4.6.2

  • No dependencies.

.NET 6.0

.NET 7.0

.NET 8.0

.NET Standard 2.0

  • No dependencies.

Version Downloads Last updated
8.0.0 11 08/17/2024