System.Data.OleDb
9.0.5
Prefix Reserved
See the version list below for details.
dotnet add package System.Data.OleDb --version 9.0.5
NuGet\Install-Package System.Data.OleDb -Version 9.0.5
<PackageReference Include="System.Data.OleDb" Version="9.0.5" />
<PackageVersion Include="System.Data.OleDb" Version="9.0.5" />
<PackageReference Include="System.Data.OleDb" />
paket add System.Data.OleDb --version 9.0.5
#r "nuget: System.Data.OleDb, 9.0.5"
#addin nuget:?package=System.Data.OleDb&version=9.0.5
#tool nuget:?package=System.Data.OleDb&version=9.0.5
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
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.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.6.2
- No dependencies.
-
.NETStandard 2.0
- No dependencies.
-
net8.0
- System.Configuration.ConfigurationManager (>= 9.0.5)
- System.Diagnostics.PerformanceCounter (>= 9.0.5)
-
net9.0
- System.Configuration.ConfigurationManager (>= 9.0.5)
- System.Diagnostics.PerformanceCounter (>= 9.0.5)
NuGet packages (300)
Showing the top 5 NuGet packages that depend on System.Data.OleDb:
| Package | 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. |
|
|
Microsoft.SqlServer.SqlManagementObjects
The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database. |
|
|
Stimulsoft.Reports.Engine.NetCore
The native .NET Core cross platform report engine is a part of the reporting tool for .NET Core and .NET frameworks, that renders reports from getting data from the source, building bands, calculating aggregate functions, charting, applying styles, conditions, filtering, sorting, and more. Also, the report engine has algorithms for exporting reports to various formats such as PDF, Rich Text, Excel, and others. |
|
|
EnterpriseLibrary.Data.NetCore
The Data Access Application Block simplifies the development of tasks that implement common data access functionality. Applications can use this application block in a variety of situations, such as reading data for display, passing data through application layers, and submitting changed data back to the database system. |
|
|
Stimulsoft.Reports.Engine
The engine is a part of the reporting tool that renders reports from getting data from the source, building bands, calculating aggregate functions, charting, applying styles, conditions, filtering, sorting, and more. Also, the report engine has algorithms for exporting reports to various formats such as PDF, Rich Text, Excel, and others. The engine supports .NET and .NET Core frameworks. |
GitHub repositories (32)
Showing the top 20 popular GitHub repositories that depend on System.Data.OleDb:
| Repository | Stars |
|---|---|
|
microsoft/PowerToys
Windows system utilities to maximize productivity
|
|
|
Flow-Launcher/Flow.Launcher
:mag: Quick file search & app launcher for Windows with community-made plugins
|
|
|
DotNetNext/SqlSugar
.Net aot ORM Fastest ORM DB2 Hana Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
|
|
|
umbraco/Umbraco-CMS
Umbraco is a free and open source .NET content management system helping you deliver delightful digital experiences.
|
|
|
dotnetcore/FreeSql
.NET aot orm, VB.NET/C# orm, Mysql/PostgreSQL/SqlServer/Oracle orm, Sqlite/Firebird/Clickhouse/DuckDB orm, 达梦/金仓/虚谷/翰高/高斯 orm, 神通 orm, 南大通用 orm, 国产 orm, TDengine orm, QuestDB orm, MsAccess orm.
|
|
|
linq2db/linq2db
Linq to database provider.
|
|
|
ariacom/Seal-Report
Database Reporting Tool and Tasks (.Net)
|
|
|
TabularEditor/TabularEditor
This is the code repository and issue tracker for Tabular Editor 2.X (free, open-source version). This repository is being maintained by Daniel Otykier.
|
|
|
DotSpatial/DotSpatial
Geographic information system library written for .NET
|
|
|
dotnet/dotnet-api-docs
.NET API reference documentation (.NET 5+, .NET Core, .NET Framework)
|
|
|
paillave/Etl.Net
Mass processing data with a complete ETL for .net developers
|
|
|
aelassas/wexflow
Workflow Engine and Automation Platform
|
|
|
dotnet/dotnet
Home of .NET's Virtual Monolithic Repository which includes all the code needed to build the .NET SDK.
|
|
|
aspose-words/Aspose.Words-for-.NET
Aspose.Words for .NET examples, plugins and showcases
|
|
|
DataDog/dd-trace-dotnet
.NET Client Library for Datadog APM
|
|
|
majorsilence/My-FyiReporting
Majorsilence Reporting, .NET report designer, viewer, and pdf creation. Fork of fyireporting,
|
|
|
BruTile/BruTile
BruTile is a .NET library to access tile services like those of OpenStreetMap, MapBox or GeodanMaps.
|
|
|
cairoshell/ManagedShell
A library for creating Windows shell replacements using .NET.
|
|
|
ixre/cms
DDD 开源.NET CMS、跨平台, 兼容.NET Core和ASP.NET,支持Docker容器
|
|
|
TortugaResearch/Tortuga.Chain
A fluent ORM for .NET
|