Pomelo.EntityFrameworkCore.MySql 8.0.2

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

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

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

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.2" />

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.2" />
                    

                            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.2

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

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

#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.2
                    

                            Install Pomelo.EntityFrameworkCore.MySql as a Cake Addin

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

                            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. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.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.2 && <= 8.0.999)
- MySqlConnector (>= 2.3.5)

NuGet packages (867)

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

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

GitHub repositories (140)

Showing the top 20 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.8K
bitwarden/server Bitwarden infrastructure/backend (API, database, Docker, etc).	16.7K
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.6K
elsa-workflows/elsa-core A .NET workflows library	7.1K
danielgerlag/workflow-core Lightweight workflow engine for .NET Standard	5.6K
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
dotnetcore/Util Util是一个.Net平台下的应用框架，旨在提升中小团队的开发能力，由工具类、分层架构基类、Ui组件，配套代码生成模板，权限等组成。	4.6K
dotnet/aspire Tools, templates, and packages to accelerate building observable, production-ready apps	4.6K
dotnetcore/WTM Use WTM to write .netcore app fast !!!	4.3K
Xabaril/AspNetCore.Diagnostics.HealthChecks Enterprise HealthChecks for ASP.NET Core Diagnostics Package	4.3K
dotnetcore/DotnetSpider DotnetSpider, a .NET standard web crawling library. It is lightweight, efficient and fast high-level web crawling & scraping framework	4.1K
cq-panda/Vue.NetCore (已支持sqlsugar).NetCore、.Net6、Vue2、Vue3、Vite、TypeScript、Element plus+uniapp前后端分离，全自动生成代码；支持移动端(ios/android/h5/微信小程序。http://www.volcore.xyz/	4.1K
Ombi-app/Ombi Want a Movie or TV Show on Plex/Emby/Jellyfin? Use Ombi!	3.9K
borisdj/EFCore.BulkExtensions Entity Framework EF Core efcore Bulk Batch Extensions with BulkCopy in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLite, Oracle	3.8K
skoruba/IdentityServer4.Admin The administration for the IdentityServer4 and Asp.Net Core Identity	3.6K
linq2db/linq2db Linq to database provider.	3.1K
dotnetcore/osharp OSharp是一个基于.Net6.0的快速开发框架，框架对 AspNetCore 的配置、依赖注入、日志、缓存、实体框架、Mvc(WebApi)、身份认证、功能权限、数据权限等模块进行更高一级的自动化封装，并规范了一套业务实现的代码结构与操作流程，使 .Net 框架更易于应用到实际项目开发中。	2.8K
loic-sharma/BaGet A lightweight NuGet and symbol server	2.7K
liukuo362573/YiShaAdmin 基于 .NET Core MVC 的权限管理系统，代码易读易懂、界面简洁美观	2.5K
Squidex/squidex Headless CMS and Content Managment Hub	2.4K

Version	Downloads	Last updated
9.0.0-preview.3.efcore.9.0.0	313,541	2/23/2025
9.0.0-preview.2.efcore.9.0.0	253,382	12/13/2024
9.0.0-preview.1	56,465	2/28/2024
8.0.3	734,710	3/2/2025
8.0.2	13,089,210	3/16/2024
8.0.1	511,103	2/28/2024
8.0.0	1,912,685	2/13/2024
8.0.0-beta.2	825,587	11/18/2023
8.0.0-beta.1	64,930	9/29/2023
7.0.0	13,385,721	1/16/2023
7.0.0-silver.1	266,007	12/14/2022
7.0.0-alpha.1	175,568	11/16/2022
6.0.3	580,577	3/16/2024
6.0.2	15,810,503	7/24/2022
6.0.1	6,812,250	1/22/2022
6.0.0	3,205,379	11/9/2021
6.0.0-rc.2	61,721	11/9/2021
6.0.0-rc.1	3,033	11/9/2021
6.0.0-preview.7	26,086	10/7/2021
6.0.0-preview.6	1,096	10/4/2021
6.0.0-preview.5	28,809	6/27/2021
6.0.0-preview.4	15,681	5/25/2021
5.0.4	1,250,544	1/22/2022
5.0.3	582,816	11/9/2021
5.0.2	775,388	10/4/2021
5.0.1	2,113,799	6/27/2021
5.0.0	2,008,934	4/28/2021
5.0.0-beta.2	5,560	4/28/2021
5.0.0-beta.1	86,016	4/22/2021
5.0.0-alpha.2	1,647,932	11/12/2020
5.0.0-alpha.1	84,384	11/5/2020
3.2.7	1,039,067	10/4/2021
3.2.6	514,215	6/27/2021
3.2.5	252,426	4/21/2021
3.2.4	3,038,796	11/2/2020
3.2.3	510,831	10/13/2020
3.2.2	367,937	9/30/2020
3.2.1	125,853	9/23/2020
3.2.0	278,028	9/16/2020
3.1.2	1,697,226	7/22/2020
3.1.1	4,324,615	1/29/2020
3.1.0	959,483	12/16/2019
3.1.0-rc1.final	33,302	12/6/2019
3.0.1	134,281	12/4/2019
3.0.0	252,160	11/18/2019
3.0.0-rc3.final	42,982	11/7/2019
3.0.0-rc2.final	6,504	11/5/2019
3.0.0-rc1.final	154,185	10/6/2019
2.2.6	1,717,737	10/15/2019
2.2.0	4,683,767	2/7/2019
2.1.4	2,301,894	11/30/2018
2.1.2	1,240,729	9/4/2018
2.1.1	768,042	7/7/2018
2.1.0	222,328	7/11/2018
2.0.1	1,064,731	11/26/2017
2.0.0.1	67,150	10/27/2017
2.0.0	355,169	9/19/2017
1.1.2	393,467	5/6/2017
1.1.0	61,750	11/29/2016
1.0.1	18,307	10/29/2016
1.0.0	43,465	8/5/2016