System.Data.OleDb 8.0.0

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org. Prefix Reserved
There is a newer prerelease version of this package available.
See the version list below for details.
dotnet add package System.Data.OleDb --version 8.0.0
NuGet\Install-Package System.Data.OleDb -Version 8.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="System.Data.OleDb" Version="8.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add System.Data.OleDb --version 8.0.0
#r "nuget: System.Data.OleDb, 8.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install System.Data.OleDb as a Cake Addin
#addin nuget:?package=System.Data.OleDb&version=8.0.0

// Install System.Data.OleDb as a Cake Tool
#tool nuget:?package=System.Data.OleDb&version=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.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 is compatible.  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 is compatible.  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. 
.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. 
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (248)

Showing the top 5 NuGet packages that depend on System.Data.OleDb:

Package Downloads
Microsoft.Windows.Compatibility The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

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 ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

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.

Dynamicweb.Core

Core API containing contracts and system-wide base objects

Stimulsoft.Reports.Engine.NetCore The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

The native .NET Core report engine is a part of the reporting tool for .NET Standard, .NET Core and .NET, 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.

Dynamicweb.Data

Data access API

GitHub repositories (27)

Showing the top 5 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 Simple Easy 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
The simple, flexible and friendly ASP.NET CMS used by more than 730.000 websites
dotnetcore/FreeSql
🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.
Version Downloads Last updated
9.0.0-preview.1.24080.9 1,416 2/13/2024
8.0.0 570,775 11/14/2023
8.0.0-rc.2.23479.6 16,227 10/10/2023
8.0.0-rc.1.23419.4 10,626 9/12/2023
8.0.0-preview.7.23375.6 9,251 8/8/2023
8.0.0-preview.6.23329.7 4,936 7/11/2023
8.0.0-preview.5.23280.8 3,398 6/13/2023
8.0.0-preview.4.23259.5 9,632 5/16/2023
8.0.0-preview.3.23174.8 20,115 4/11/2023
8.0.0-preview.2.23128.3 5,265 3/14/2023
8.0.0-preview.1.23110.8 15,686 2/21/2023
7.0.0 3,861,677 11/7/2022
7.0.0-rc.2.22472.3 10,555 10/11/2022
7.0.0-rc.1.22426.10 63,186 9/14/2022
7.0.0-preview.7.22375.6 11,889 8/9/2022
7.0.0-preview.6.22324.4 1,599 7/12/2022
7.0.0-preview.5.22301.12 1,756 6/14/2022
7.0.0-preview.4.22229.4 11,144 5/10/2022
7.0.0-preview.3.22175.4 2,726 4/13/2022
7.0.0-preview.2.22152.2 12,085 3/14/2022
7.0.0-preview.1.22076.8 2,918 2/17/2022
6.0.2-mauipre.1.22102.15 1,257 2/15/2022
6.0.2-mauipre.1.22054.8 6,067 1/19/2022
6.0.0 10,367,278 11/8/2021
6.0.0-rc.2.21480.5 4,602 10/12/2021
6.0.0-rc.1.21451.13 9,012 9/14/2021
6.0.0-preview.7.21377.19 3,418 8/10/2021
6.0.0-preview.6.21352.12 2,289 7/14/2021
6.0.0-preview.5.21301.5 6,303 6/15/2021
6.0.0-preview.4.21253.7 26,467 5/24/2021
6.0.0-preview.3.21201.4 12,032 4/8/2021
6.0.0-preview.2.21154.6 16,770 3/11/2021
6.0.0-preview.1.21102.12 5,075 2/12/2021
5.0.0 22,627,457 11/9/2020
5.0.0-rc.2.20475.5 9,439 10/13/2020
5.0.0-rc.1.20451.14 5,018 9/14/2020
5.0.0-preview.8.20407.11 6,598 8/25/2020
5.0.0-preview.7.20364.11 38,706 7/21/2020
5.0.0-preview.6.20305.6 5,362 6/25/2020
5.0.0-preview.5.20278.1 4,163 6/10/2020
5.0.0-preview.4.20251.6 9,825 5/18/2020
5.0.0-preview.3.20214.6 25,670 4/23/2020
5.0.0-preview.2.20160.6 1,393 4/2/2020
5.0.0-preview.1.20120.5 8,648 3/16/2020
4.7.1 3,723,078 5/12/2020
4.7.0 11,907,459 12/3/2019
4.7.0-preview3.19551.4 2,053 11/13/2019
4.7.0-preview2.19523.17 12,067 11/1/2019
4.7.0-preview1.19504.10 9,749 10/15/2019
4.6.0 3,427,883 9/23/2019
4.6.0-rc1.19456.4 7,166 9/16/2019
4.6.0-preview9.19421.4 3,481 9/4/2019
4.6.0-preview9.19416.11 415 9/4/2019
4.6.0-preview8.19405.3 19,560 8/13/2019
4.6.0-preview7.19362.9 10,516 7/23/2019
4.6.0-preview6.19303.8 575,238 6/12/2019
4.6.0-preview6.19264.9 588 9/4/2019