EF Core MySQL Discover how to install and use this provider

3 major NuGet packages support MySQL:

• MySql.Data.EntityFrameworkCore
• Devart.Data.MySql.EFCore
• Pomelo.EntityFrameworkCore.MySql

MySql.Data.EntityFrameworkCore

You can also use MySQL Connector/Net which integrates support for Entity Framework Core. MySql.Data.EntityFrameworkCore allows Entity Framework Core to be used with MySQL. The provider is maintained as part of the MySQL project.

Requirements

• Install Connector/Net
• MySQL Server 5.7 or higher

How to Use MySQL Database Provider

To use MySQL database provider, the first step is to install MySql.Data.EntityFrameworkCore NuGet package. Let's consider a simple model which contains three entities.

Now to use Entity Framework Core with MySQL database, override the OnConfiguring method in the context class and set the MySQL data provider using UseMySQL method.

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
    optionsBuilder.UseMySQL("server=localhost;database=library;user=user;password=password");
}

Limitations

• The MySQL Connector/Net implementation of EF Core has no support for Memory-Optimized Tables yet.
• The following table shows Maximum Length of strings types supported by the MySQL Connector/Net implementation of EF Core.

Devart.Data.MySql.EFCore

Devart.Data.MySql.EFCore is an Entity Framework Core provider created by Devart.

How to Use Devart.Data.MySql.EFCore Provider

To use Devart.Data.MySql.EFCore provider, the first step is to install the Devart.Data.MySql.EFCore NuGet package.

Now to use Entity Framework Core with SQLite database, override the OnConfiguring method in the context class and set the SQLite data provider using UseMySql method.

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
	optionsBuilder.UseMySql("server=localhost;database=library;user=user;password=password");
}