System.Data.OleDb 9.0.0-rc.1.24431.7
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 = ""; // Fill in
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
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 |
---|---|
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
154 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
151 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
117 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
61 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
46 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
24 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
21 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
14 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
12 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
9 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
7 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
3 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
2 |
Magicodes.Next.MicrosoftAccess
The next version of [Magicodes.IE]( https://github.com/dotnetcore/Magicodes.IE ), a more friendly library to use in ABP framework.
|
1 |
https://go.microsoft.com/fwlink/?LinkID=799421
.NET Framework 4.6.2
- No dependencies.
.NET 8.0
- System.Configuration.ConfigurationManager (>= 9.0.0-rc.1.24431.7)
- System.Diagnostics.PerformanceCounter (>= 9.0.0-rc.1.24431.7)
.NET 9.0
- System.Configuration.ConfigurationManager (>= 9.0.0-rc.1.24431.7)
- System.Diagnostics.PerformanceCounter (>= 9.0.0-rc.1.24431.7)
.NET Standard 2.0
- No dependencies.