Pomelo.EntityFrameworkCore.MySql 8.0.3

There is a newer prerelease version of this package available.
See the version list below for details.

dotnet add package Pomelo.EntityFrameworkCore.MySql --version 8.0.3

NuGet\Install-Package Pomelo.EntityFrameworkCore.MySql -Version 8.0.3

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="8.0.3" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="Pomelo.EntityFrameworkCore.MySql" Version="8.0.3" />
                    

                            Directory.Packages.props

<PackageReference Include="Pomelo.EntityFrameworkCore.MySql" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add Pomelo.EntityFrameworkCore.MySql --version 8.0.3

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Pomelo.EntityFrameworkCore.MySql, 8.0.3"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

#addin nuget:?package=Pomelo.EntityFrameworkCore.MySql&version=8.0.3
                    

                            Install Pomelo.EntityFrameworkCore.MySql as a Cake Addin

#tool nuget:?package=Pomelo.EntityFrameworkCore.MySql&version=8.0.3
                    

                            Install Pomelo.EntityFrameworkCore.MySql as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

About

Pomelo.EntityFrameworkCore.MySql is the Entity Framework Core (EF Core) provider for MySQL, MariaDB, Amazon Aurora, Azure Database for MySQL and other MySQL-compatible databases.

It is build on top of MySqlConnector.

How to Use

public class Startup
{
    public void ConfigureServices(IServiceCollection services)
    {
        // Replace with your connection string.
        var connectionString = "server=localhost;user=root;password=1234;database=ef";

        // Replace with your server version and type.
        // Use 'MariaDbServerVersion' for MariaDB.
        // Alternatively, use 'ServerVersion.AutoDetect(connectionString)'.
        // For common usages, see pull request #1233.
        var serverVersion = new MySqlServerVersion(new Version(8, 0, 29));

        // Replace 'YourDbContext' with the name of your own DbContext derived class.
        services.AddDbContext<YourDbContext>(
            dbContextOptions => dbContextOptions
                .UseMySql(connectionString, serverVersion)
                // The following three options help with debugging, but should
                // be changed or removed for production.
                .LogTo(Console.WriteLine, LogLevel.Information)
                .EnableSensitiveDataLogging()
                .EnableDetailedErrors()
        );
    }
}

Key Features

JSON support (both Newtonsoft.Json and System.Text.Json)
Spatial support
High performance

JSON support
- Pomelo.EntityFrameworkCore.MySql.Json.Microsoft
- Pomelo.EntityFrameworkCore.MySql.Json.Newtonsoft
Spatial support
- Pomelo.EntityFrameworkCore.MySql.NetTopologySuite
Other Packages
- MySqlConnector
- Microsoft.EntityFrameworkCore

License

Pomelo.EntityFrameworkCore.MySql is released as open source under the MIT license.

Feedback

Bug reports and contributions are welcome at our GitHub repository.

Product	Compatible and additional computed target framework versions.
.NET	net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net8.0
- Microsoft.EntityFrameworkCore.Relational (>= 8.0.13 && <= 8.0.999)
- MySqlConnector (>= 2.3.5)

NuGet packages (840)

Showing the top 5 NuGet packages that depend on Pomelo.EntityFrameworkCore.MySql:

Package	Downloads
Microting.eForm Package Description	4.0M
Pomelo.EntityFrameworkCore.MySql.Design Package Description	2.9M
EFCore.BulkExtensions.MySql EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on MySQL	2.3M
Pomelo.EntityFrameworkCore.MySql.NetTopologySuite NetTopologySuite support for Pomelo's MySQL provider for Entity Framework Core.	1.7M
JoreNoe Redis性能优化	1.6M

GitHub repositories (131)

Showing the top 5 popular GitHub repositories that depend on Pomelo.EntityFrameworkCore.MySql:

Repository	Stars
dotnet/aspnetcore ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.	36.4K
bitwarden/server Bitwarden infrastructure/backend (API, database, Docker, etc).	16.3K
abpframework/abp Open-source web application framework for ASP.NET Core! Offers an opinionated architecture to build enterprise software solutions with best practices on top of the .NET. Provides the fundamental infrastructure, cross-cutting-concern implementations, startup templates, application modules, UI themes, tooling and documentation.	13.3K
elsa-workflows/elsa-core A .NET workflows library	7.0K
aspnet/Mvc [Archived] ASP.NET Core MVC is a model view controller framework for building dynamic web sites with clean separation of concerns, including the merged MVC, Web API, and Web Pages w/ Razor. Project moved to https://github.com/aspnet/AspNetCore	5.6K

Version	Downloads	Last updated
9.0.0-preview.3.efcore.9.0.0	83,743	2/23/2025
9.0.0-preview.2.efcore.9.0.0	158,830	12/13/2024
9.0.0-preview.1	46,048	2/28/2024
8.0.3	126,869	3/2/2025
8.0.2	10,150,323	3/16/2024
8.0.1	453,695	2/28/2024
8.0.0	1,637,037	2/13/2024
8.0.0-beta.2	760,575	11/18/2023
8.0.0-beta.1	59,529	9/29/2023
7.0.0	12,442,559	1/16/2023
7.0.0-silver.1	256,095	12/14/2022
7.0.0-alpha.1	174,169	11/16/2022
6.0.3	473,698	3/16/2024
6.0.2	15,333,350	7/24/2022
6.0.1	6,678,141	1/22/2022
6.0.0	3,114,133	11/9/2021
6.0.0-rc.2	61,672	11/9/2021
6.0.0-rc.1	2,983	11/9/2021
6.0.0-preview.7	25,317	10/7/2021
6.0.0-preview.6	1,041	10/4/2021
6.0.0-preview.5	28,129	6/27/2021
6.0.0-preview.4	15,560	5/25/2021
5.0.4	1,200,612	1/22/2022
5.0.3	573,763	11/9/2021
5.0.2	757,828	10/4/2021
5.0.1	2,089,331	6/27/2021
5.0.0	1,965,361	4/28/2021
5.0.0-beta.2	5,508	4/28/2021
5.0.0-beta.1	80,641	4/22/2021
5.0.0-alpha.2	1,615,043	11/12/2020
5.0.0-alpha.1	80,590	11/5/2020
3.2.7	1,012,475	10/4/2021
3.2.6	511,320	6/27/2021
3.2.5	251,099	4/21/2021
3.2.4	3,014,720	11/2/2020
3.2.3	503,309	10/13/2020
3.2.2	365,373	9/30/2020
3.2.1	124,780	9/23/2020
3.2.0	276,253	9/16/2020
3.1.2	1,677,918	7/22/2020
3.1.1	4,299,657	1/29/2020
3.1.0	942,393	12/16/2019
3.1.0-rc1.final	32,072	12/6/2019
3.0.1	131,696	12/4/2019
3.0.0	251,295	11/18/2019
3.0.0-rc3.final	42,452	11/7/2019
3.0.0-rc2.final	6,293	11/5/2019
3.0.0-rc1.final	153,957	10/6/2019
2.2.6	1,706,316	10/15/2019
2.2.0	4,667,220	2/7/2019
2.1.4	2,295,484	11/30/2018
2.1.2	1,237,110	9/4/2018
2.1.1	765,226	7/7/2018
2.1.0	220,244	7/11/2018
2.0.1	1,059,752	11/26/2017
2.0.0.1	66,554	10/27/2017
2.0.0	353,483	9/19/2017
1.1.2	368,454	5/6/2017
1.1.0	61,604	11/29/2016
1.0.1	18,191	10/29/2016
1.0.0	39,655	8/5/2016