System.Data.Odbc
9.0.0-preview.3.24172.9
Prefix Reserved
See the version list below for details.
dotnet add package System.Data.Odbc --version 9.0.0-preview.3.24172.9
NuGet\Install-Package System.Data.Odbc -Version 9.0.0-preview.3.24172.9
<PackageReference Include="System.Data.Odbc" Version="9.0.0-preview.3.24172.9" />
paket add System.Data.Odbc --version 9.0.0-preview.3.24172.9
#r "nuget: System.Data.Odbc, 9.0.0-preview.3.24172.9"
// Install System.Data.Odbc as a Cake Addin #addin nuget:?package=System.Data.Odbc&version=9.0.0-preview.3.24172.9&prerelease // Install System.Data.Odbc as a Cake Tool #tool nuget:?package=System.Data.Odbc&version=9.0.0-preview.3.24172.9&prerelease
About
This package implements a data provider for ODBC data sources.
Key Features
Allows access to ODBC data sources.
How to Use
This is a basic example of retrieving the results of a query using an OdbcDataReader. For examples of using an OdbcDataAdapter, and of updating an ODBC data source, please see the documentation.
using System.Data.Odbc;
string connectionString = ""; // Fill in
string queryString = "SELECT DISTINCT CustomerID FROM Orders";
using OdbcConnection connection = new OdbcConnection(connectionString);
using OdbcCommand command = new OdbcCommand(queryString, connection);
connection.Open();
using OdbcDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Console.WriteLine("CustomerID={0}", reader[0]);
}
Main Types
- OdbcConnection represents a connection to an ODBC data source.
- OdbcCommand represents an SQL statement or stored procedure to execute against an ODBC data source..
- OdbcDataReader provides a way of reading a forward-only stream of data rows from an ODBC data source.
- OdbcDataAdapter represents a set of data commands and a database connection that are used to fill a DataSet and update the ODBC data source.
Additional Documentation
Related Packages
System.Data.OleDb is a similar package for accessing OLE DB data sources.
Feedback & Contributing
System.Data.Odbc 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. |
| .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.Text.Encoding.CodePages (>= 9.0.0-preview.3.24172.9)
-
net9.0
- System.Text.Encoding.CodePages (>= 9.0.0-preview.3.24172.9)
NuGet packages (214)
Showing the top 5 NuGet packages that depend on System.Data.Odbc:
| 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.PowerShell.SDK
Runtime for hosting PowerShell |
|
|
IKVM
Java SE 8 Virtual Machine for .NET |
|
|
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. |
GitHub repositories (25)
Showing the top 5 popular GitHub repositories that depend on System.Data.Odbc:
| Repository | Stars |
|---|---|
|
DotNetNext/SqlSugar
.Net aot ORM Fastest ORM 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, 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, DuckDB orm, TDengine orm, QuestDB orm, MsAccess orm.
|
|
|
linq2db/linq2db
Linq to database provider.
|
|
|
FastReports/FastReport
Free Open Source Reporting tool for .NET6/.NET Core/.NET Framework that helps your application generate document-like reports
|