Entity Framework Supported Database Providers Discover About Providers
What database provider are supported in Entity Framework?
Data Provider is a set of libraries that are used to connect to a database, executing commands, and retrieving results. For example, SQL data provider for SQL, Oracle data provider for Oracle, OLE DB data provider for access, excel or mysql, etc.
Entity Framework uses a provider model to allow EF to be used to access many different databases.
Microsoft.EntityFrameworkCore.SqlServer
It allows Entity Framework Core to be used with Microsoft SQL Server (including SQL Azure). The provider is maintained as part of the EntityFramework GitHub project.
Install
PM> Install-Package Microsoft.EntityFrameworkCore.SqlServer
NuGet Url: Microsoft.EntityFrameworkCore.SqlServer
System.Data.SQLite
The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. This package includes support for LINQ and Entity Framework 6.
Install
PM> Install-Package System.Data.SQLite
NuGet Url: https://www.nuget.org/packages/System.Data.SQLite/
Microsoft.EntityFrameworkCore.Sqlite
This database provider allows Entity Framework Core to be used with SQLite. The provider is maintained as part of the EntityFramework GitHub project.
Install
PM> Install-Package Microsoft.EntityFrameworkCore.Sqlite
The SQLite provider has some migrations limitations. Most of these limitations are a result of limitations in the underlying SQLite database engine and are not specific to EF.
NuGet Url: Microsoft.EntityFrameworkCore.Sqlite
Npgsql.EntityFrameworkCore.PostgreSQL
It allows Entity Framework Core to be used with PostgreSQL. The provider is maintained as part of the Npgsql.
Install
PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL
NuGet Url: Npgsql.EntityFrameworkCore.PostgreSQL
IBM.EntityFrameworkCore
It allows Entity Framework Core to be used with IBM Data Server (DB2). The provider is maintained by IBM.
Install
PM> Install-Package IBM.EntityFrameworkCore
NuGet Url: IBM.EntityFrameworkCore
MySql.Data.EntityFrameworkCore
It allows Entity Framework Core to be used with MySQL. The provider is maintained as part of the MySQL project.
Install
PM> Install-Package MySql.Data.EntityFrameworkCore -Pre
NuGet Url: MySql.Data.EntityFrameworkCore
Pomelo.EntityFrameworkCore.MySql
It allows Entity Framework Core to be used with MySQL. The provider is maintained as part of the Pomelo Foundation Project.
Install
PM> Install-Package Pomelo.EntityFrameworkCore.MySql
NuGet Url: Pomelo.EntityFrameworkCore.MySql
Connector/Net
Connector/Net is a fully-managed ADO.NET driver for MySQL.
Install
See the MySQL Connector documentation for installation instructions.
EntityFrameworkCore.SqlServerCompact
It allows Entity Framework Core to be used with SQL Server Compact Edition. The provider is maintained as part of the ErikEJ/EntityFramework.SqlServerCompact GitHub Project.
Install
To work with SQL Server Compact Edition 4.0, install the EntityFrameworkCore.SqlServerCompact40.
PM> Install-Package EntityFrameworkCore.SqlServerCompact40
To work with SQL Server Compact Edition 3.5, install the EntityFrameworkCore.SqlServerCompact35.
PM> Install-Package EntityFrameworkCore.SqlServerCompact35
Oracle Data Provider for .NET
Use Entity Framework with Oracle Data Provider for .NET.
Install
See the Oracle Data Provider for .NET documentation for installation instructions.
In-Memory (for Testing)
It allows Entity Framework Core to be used with an in-memory database. This is useful when testing code that uses Entity Framework Core. The provider is maintained as part of the EntityFramework GitHub project.
Install
PM> Install-Package Microsoft.EntityFrameworkCore.InMemory
NuGet Url: Microsoft.EntityFrameworkCore.InMemory
Devart
Devart is a third party provider writer that offers database providers for a wide range of databases (MySQL, Oracle, PostgreSQL, SQLite, DB2, and more). Devart dotConnect is a commercial third party provider. Entity Framework support is only available in paid versions of dotConnect.
Install
See the Devart dotConnect documentation for installation instructions.
DataDirect
Progress DataDirect offers unique data connectivity solutions for enterprises needing to better integrate data across Relational, Big Data and Cloud Databases.
Install
See the DataDirect documentation for installation instructions.
MyCat
It allows Entity Framework Core to be used with MyCat. The provider is maintained as part of the Pomelo
Install
Download and run the latest release from the project site.
EntityFrameworkCore.FirebirdSQL
It allows Entity Framework Core to be used with FirebirdSQL. The provider is maintained as part of the ralmsdeveloper/EntityFrameworkCore.FirebirdSQL GitHub Project.
Install
PM> Install-Package EntityFrameworkCore.FirebirdSQL
NuGet Url: Microsoft.EntityFrameworkCore.InMemory
ZZZ Projects