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