Pomelo.EntityFrameworkCore.MySql 9.0.0-preview.3.efcore.9.0.0

This is a prerelease version of Pomelo.EntityFrameworkCore.MySql.

dotnet add package Pomelo.EntityFrameworkCore.MySql --version 9.0.0-preview.3.efcore.9.0.0

NuGet\Install-Package Pomelo.EntityFrameworkCore.MySql -Version 9.0.0-preview.3.efcore.9.0.0

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="9.0.0-preview.3.efcore.9.0.0" />

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

<PackageVersion Include="Pomelo.EntityFrameworkCore.MySql" Version="9.0.0-preview.3.efcore.9.0.0" />
                    

                            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 9.0.0-preview.3.efcore.9.0.0

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

#r "nuget: Pomelo.EntityFrameworkCore.MySql, 9.0.0-preview.3.efcore.9.0.0"

#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=9.0.0-preview.3.efcore.9.0.0&prerelease
                    

                            Install Pomelo.EntityFrameworkCore.MySql as a Cake Addin

#tool nuget:?package=Pomelo.EntityFrameworkCore.MySql&version=9.0.0-preview.3.efcore.9.0.0&prerelease
                    

                            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 (>= 9.0.0 && <= 9.0.999)
- MySqlConnector (>= 2.4.0)

NuGet packages (848)

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	3.0M
EFCore.BulkExtensions.MySql EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on MySQL	2.6M
Pomelo.EntityFrameworkCore.MySql.NetTopologySuite NetTopologySuite support for Pomelo's MySQL provider for Entity Framework Core.	1.8M
JoreNoe Redis和Dapper增加多连接方式，并且优化性能	1.7M

GitHub repositories (139)

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.5K
bitwarden/server Bitwarden infrastructure/backend (API, database, Docker, etc).	16.4K
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.4K
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
danielgerlag/workflow-core Lightweight workflow engine for .NET Standard	5.6K
dotnetcore/Util Util是一个.Net平台下的应用框架，旨在提升中小团队的开发能力，由工具类、分层架构基类、Ui组件，配套代码生成模板，权限等组成。	4.6K
dotnet/aspire Tools, templates, and packages to accelerate building observable, production-ready apps	4.4K
dotnetcore/WTM Use WTM to write .netcore app fast !!!	4.3K
Xabaril/AspNetCore.Diagnostics.HealthChecks Enterprise HealthChecks for ASP.NET Core Diagnostics Package	4.2K
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.0K
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	133,597	2/23/2025
9.0.0-preview.2.efcore.9.0.0	181,749	12/13/2024
9.0.0-preview.1	49,046	2/28/2024
8.0.3	236,551	3/2/2025
8.0.2	10,860,759	3/16/2024
8.0.1	468,529	2/28/2024
8.0.0	1,699,738	2/13/2024
8.0.0-beta.2	776,607	11/18/2023
8.0.0-beta.1	60,837	9/29/2023
7.0.0	12,655,198	1/16/2023
7.0.0-silver.1	260,686	12/14/2022
7.0.0-alpha.1	174,526	11/16/2022
6.0.3	508,485	3/16/2024
6.0.2	15,443,046	7/24/2022
6.0.1	6,709,606	1/22/2022
6.0.0	3,134,349	11/9/2021
6.0.0-rc.2	61,681	11/9/2021
6.0.0-rc.1	2,992	11/9/2021
6.0.0-preview.7	25,498	10/7/2021
6.0.0-preview.6	1,052	10/4/2021
6.0.0-preview.5	28,233	6/27/2021
6.0.0-preview.4	15,591	5/25/2021
5.0.4	1,212,173	1/22/2022
5.0.3	576,361	11/9/2021
5.0.2	762,561	10/4/2021
5.0.1	2,094,542	6/27/2021
5.0.0	1,972,838	4/28/2021
5.0.0-beta.2	5,522	4/28/2021
5.0.0-beta.1	81,210	4/22/2021
5.0.0-alpha.2	1,618,701	11/12/2020
5.0.0-alpha.1	80,945	11/5/2020
3.2.7	1,019,269	10/4/2021
3.2.6	512,155	6/27/2021
3.2.5	251,427	4/21/2021
3.2.4	3,020,660	11/2/2020
3.2.3	505,129	10/13/2020
3.2.2	366,158	9/30/2020
3.2.1	125,126	9/23/2020
3.2.0	276,663	9/16/2020
3.1.2	1,682,979	7/22/2020
3.1.1	4,306,114	1/29/2020
3.1.0	944,068	12/16/2019
3.1.0-rc1.final	32,082	12/6/2019
3.0.1	132,388	12/4/2019
3.0.0	251,507	11/18/2019
3.0.0-rc3.final	42,681	11/7/2019
3.0.0-rc2.final	6,364	11/5/2019
3.0.0-rc1.final	154,002	10/6/2019
2.2.6	1,709,422	10/15/2019
2.2.0	4,671,399	2/7/2019
2.1.4	2,297,216	11/30/2018
2.1.2	1,238,051	9/4/2018
2.1.1	766,111	7/7/2018
2.1.0	220,787	7/11/2018
2.0.1	1,060,430	11/26/2017
2.0.0.1	66,712	10/27/2017
2.0.0	353,967	9/19/2017
1.1.2	374,518	5/6/2017
1.1.0	61,634	11/29/2016
1.0.1	18,214	10/29/2016
1.0.0	40,773	8/5/2016