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
DataSetand update the OLE DB data source.
Additional Documentation
Related Packages
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.
Showing the top 20 packages that depend on System.Data.OleDb.
| Packages | Downloads |
|---|---|
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET as well as .NET Standard.
|
8 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET as well as .NET Standard.
|
9 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET as well as .NET Standard.
|
10 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET as well as .NET Standard.
|
12 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET Core as well as .NET Standard.
|
8 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET Core as well as .NET Standard.
|
9 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET Core as well as .NET Standard.
When using NuGet 3.x this package requires at least version 3.4.
|
8 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET Core as well as .NET Standard.
When using NuGet 3.x this package requires at least version 3.4.
|
10 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET Core as well as .NET Standard.
When using NuGet 3.x this package requires at least version 3.4.
|
12 |
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET Core as well as .NET Standard.
When using NuGet 3.x this package requires at least version 3.4.
|
696 |
https://go.microsoft.com/fwlink/?LinkID=799421
.NET Framework 4.6.2
- No dependencies.
.NET 6.0
- System.Configuration.ConfigurationManager (>= 8.0.0)
- System.Diagnostics.PerformanceCounter (>= 8.0.0)
.NET 7.0
- System.Configuration.ConfigurationManager (>= 8.0.0)
- System.Diagnostics.PerformanceCounter (>= 8.0.0)
.NET 8.0
- System.Configuration.ConfigurationManager (>= 8.0.0)
- System.Diagnostics.PerformanceCounter (>= 8.0.0)
.NET Standard 2.0
- No dependencies.