Supported Databases
One database may have several providers because of:
- using different ADO .Net implementations (as for SQLite)
- SQL compatibility level, that allows using new SQL features of the database engine (as for MS SQL Server)
Database | Provider name |
---|---|
ClickHouse | ClickHouse ClickHouse.MySql ClickHouse.Client ClickHouse.Octonica |
DB2 (LUW, z/OS) | DB2 DB2.LUW DB2.z/OS |
Firebird | Firebird |
Informix | Informix Informix.DB2 |
Microsoft Access | Access Access.ODBC |
Microsoft Sql Azure | |
Microsoft Sql Server | SqlServer - default compatibility level SQL Server 2008 SqlServer.2000 (removed in v4) SqlServer.2005 SqlServer.2008 SqlServer.2012 SqlServer.2014 SqlServer.2016 SqlServer.2017 SqlServer.2019 SqlServer.2022 |
Microsoft SqlCe | SqlCe |
MySql | MySql MySqlConnector MySql.Official |
Oracle | Oracle Oracle.11.Managed Oracle.11.Native Oracle.11.Devart Oracle.Managed Oracle.Native Oracle.Devart |
PostgreSQL | PostgreSQL PostgreSQL.9.2 PostgreSQL.9.3 PostgreSQL.9.5 PostgreSQL.15 |
SQLite | SQLite, SQLite.Classic - using System.Data.Sqlite SQLite.MS - using Microsoft.Data.Sqlite |
SAP HANA | SapHana SapHana.Native SapHana.Odbc |
Sybase ASE | Sybase - using Native SAP/Sybase ASE provider Sybase.Managed - using Managed Sybase/SAP ASE provider from DataAction |
DB2 iSeries | iSeriesProvider |