System.Data.OleDb 9.0.10

Prefix Reserved
.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.6.2 This package targets .NET Framework 4.6.2. The package is compatible with this framework or higher.
There is a newer prerelease version of this package available.
See the version list below for details. 
dotnet add package System.Data.OleDb --version 9.0.10
                    


                    

                
NuGet\Install-Package System.Data.OleDb -Version 9.0.10
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="9.0.10" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="System.Data.OleDb" Version="9.0.10" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="System.Data.OleDb" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add System.Data.OleDb --version 9.0.10
                    


                    

                
#r "nuget: System.Data.OleDb, 9.0.10"
#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. 
#:package System.Data.OleDb@9.0.10
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=System.Data.OleDb&version=9.0.10
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=System.Data.OleDb&version=9.0.10
                    


                            Install as a Cake Tool

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

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 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

GitHub repositories (33)

Showing the top 20 popular GitHub repositories that depend on System.Data.OleDb:

Repository Stars
microsoft/PowerToys
Microsoft PowerToys is a collection of utilities that help you customize Windows and streamline everyday tasks
Flow-Launcher/Flow.Launcher
:mag: Quick file search & app launcher for Windows with community-made plugins
DotNetNext/SqlSugar
.Net aot ORM SqlServer ORM Mongodb ORM MySql 瀚高 Postgresql ORM DB2 Hana 高斯 Duckdb C# VB.NET Sqlite ORM Oracle ORM Mysql Orm 虚谷数据库 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET9 ORM .NET8 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
dotnet/dotnet
Home of .NET's Virtual Monolithic Repository which includes all the code needed to build the .NET SDK.
aelassas/wexflow
Workflow Automation Engine
aspose-words/Aspose.Words-for-.NET
Aspose.Words for .NET examples, plugins and showcases
DataDog/dd-trace-dotnet
.NET Client Library for Datadog APM
cairoshell/ManagedShell
A library for creating Windows shell replacements using .NET.
majorsilence/My-FyiReporting
Majorsilence Reporting, .NET report designer, viewer, and pdf creation.
BruTile/BruTile
BruTile is a .NET library to access tile services like those of OpenStreetMap, MapBox or GeodanMaps.
ixre/cms
DDD 开源.NET CMS、跨平台, 兼容.NET Core和ASP.NET,支持Docker容器
TortugaResearch/Tortuga.Chain
A fluent ORM for .NET

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