Pomelo.EntityFrameworkCore.MySql is the most popular Entity Framework Core provider for MySQL compatible databases. It supports EF Core 3.1 (and lower) and uses MySqlConnector for all its database server communications.
The following versions of MySqlConnector, EF Core and .NET Standard are compatible with Pomelo.EntityFrameworkCore.MySql:
| Pomelo.EFCore.MySql | MySqlConnector | EF Core | .NET Standard | .NET Core | .NET Framework |
|---|---|---|---|---|---|
| 3.1.2 | 0.61.0+ (but < 1.0.0) | 3.1.x | 2.0 | 2.0+ | 4.6.1+ |
| 3.0.1 | 0.61.0+ (but < 1.0.0) | 3.0.x | 2.1 | 3.0+ | N/A |
| 2.2.6 | 0.59.2+ (but < 1.0.0) | 2.2.6 | 2.0 | 2.0+ | 4.6.1+ |
Pomelo.EntityFrameworkCore.MySql is tested against the latest 2 minor versions of MySQL and MariaDB. Older versions and other server implementations may be compatible (and likely are, at least partially) but are not officially supported or tested.
Currently supported versions are:
- MySQL 8.0
- MySQL 5.7
- MariaDB 10.4
- MariaDB 10.3
| Milestone | Status | Release Date |
|---|---|---|
| 3.2.0 | In Development | TBA |
| 3.1.2 | Released | 2020-07-22 |
| 3.1.1 | Released | 2020-01-15 |
| 3.1.0 | Released | 2019-12-16 |
| 3.0.1 | Released | 2019-12-04 |
| 3.0.0 | Released | 2019-11-18 |
| 2.2.6 | Released | 2019-10-15 |
| 2.2.0 | Released | 2019-02-07 |
| 2.1.4 | Released | 2018-11-29 |
To use nightly builds from our Azure DevOps feed, add a NuGet.config file in your solution root with the following contents:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<packageSources>
<add key="Pomelo" value="https://pkgs.dev.azure.com/pomelo-efcore/Pomelo.EntityFrameworkCore.MySql/_packaging/pomelo-efcore-public/nuget/v3/index.json" />
<add key="nuget.org" value="https://api.nuget.org/v3/index.json" />
</packageSources>
</configuration>We recommend to set utf8mb4 as your MySQL database default charset. This is already the server default in MySQL 8. The following statement will check your current database charset:
show variables like 'character_set_database';Ensure that your .csproj file contains the following reference:
<PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="3.1.1" />Add Pomelo.EntityFrameworkCore.MySql to the services configuration in your the Startup.cs file.
using System;
using Microsoft.EntityFrameworkCore;
using Pomelo.EntityFrameworkCore.MySql.Infrastructure;
// replace "YourNamespace" with the namespace of your application
namespace YourNamespace
{
public class Startup
{
public void ConfigureServices(IServiceCollection services)
{
// other service configurations go here
// replace "YourDbContext" with the class name of your DbContext
services.AddDbContextPool<YourDbContext>(options => options
// replace with your connection string
.UseMySql("Server=localhost;Database=ef;User=root;Password=1234;", mySqlOptions => mySqlOptions
// replace with your Server Version and Type
.ServerVersion(new Version(8, 0, 18), ServerType.MySql)
));
}
}
}View our Configuration Options Wiki Page for a list of common options.
Check out our Integration Tests for an example repository that includes a MVC Application.
Refer to Microsoft's EF Core Documentation for detailed instructions and examples on using EF Core.
Use the EF Core tool to execute scaffolding commands:
dotnet ef dbcontext scaffold "Server=localhost;Database=ef;User=root;Password=123456;TreatTinyAsBoolean=true;" "Pomelo.EntityFrameworkCore.MySql"
One of the easiest ways to contribute is to report issues and participate in discussions on issues. You can also contribute by submitting pull requests with code changes and supporting tests.
Pomelo.EntityFrameworkCore.MySql is always looking for additional core contributors. If you got a couple of hours a week and know your way around EF Core, give us a nudge.