Pomelo.EntityFrameworkCore.MySql 7.0.0

.NET 6.0

Requires NuGet 3.6 or higher.

dotnet add package Pomelo.EntityFrameworkCore.MySql --version 7.0.0
NuGet\Install-Package Pomelo.EntityFrameworkCore.MySql -Version 7.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="7.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Pomelo.EntityFrameworkCore.MySql --version 7.0.0
#r "nuget: Pomelo.EntityFrameworkCore.MySql, 7.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.
// Install Pomelo.EntityFrameworkCore.MySql as a Cake Addin
#addin nuget:?package=Pomelo.EntityFrameworkCore.MySql&version=7.0.0

// Install Pomelo.EntityFrameworkCore.MySql as a Cake Tool
#tool nuget:?package=Pomelo.EntityFrameworkCore.MySql&version=7.0.0

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

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 net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed. 
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (627)

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

Package Downloads
EFCore.BulkExtensions

EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite

Microting.eForm The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

Package Description

Pomelo.EntityFrameworkCore.MySql.Design

Package Description

Util.Datas

Util.Datas是Util应用框架的数据访问类库。 Util是一个.net core平台下的应用框架,旨在提升小型团队的开发输出能力,由常用公共操作类(工具类)、分层架构基类、Ui组件,第三方组件封装,第三方业务接口封装,配套代码生成模板,权限等组成。

OO.Data

Data Entity base types and declarations for EasyDataCore infrastructure

GitHub repositories (110)

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.
bitwarden/server
The core infrastructure backend (API, database, Docker, etc).
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 and the ASP.NET Core platforms. Provides the fundamental infrastructure, production-ready startup templates, application modules, UI themes, tooling, guides and documentation.
dotnetcore/CAP
Distributed transaction solution in micro-service base on eventually consistency, also an eventbus with Outbox pattern
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
Version Downloads Last updated
7.0.0 1,074,365 1/16/2023
7.0.0-silver.1 111,218 12/14/2022
7.0.0-alpha.1 109,515 11/16/2022
6.0.2 5,223,852 7/24/2022
6.0.1 3,995,324 1/22/2022
6.0.0 1,775,603 11/9/2021
6.0.0-rc.2 47,362 11/9/2021
6.0.0-rc.1 2,268 11/9/2021
6.0.0-preview.7 15,886 10/7/2021
6.0.0-preview.6 842 10/4/2021
6.0.0-preview.5 19,721 6/27/2021
6.0.0-preview.4 14,197 5/25/2021
5.0.4 687,485 1/22/2022
5.0.3 412,753 11/9/2021
5.0.2 539,131 10/4/2021
5.0.1 1,614,085 6/27/2021
5.0.0 1,426,954 4/28/2021
5.0.0-beta.2 5,204 4/28/2021
5.0.0-beta.1 67,438 4/22/2021
5.0.0-alpha.2 1,391,479 11/12/2020
5.0.0-alpha.1 69,684 11/5/2020
3.2.7 562,199 10/4/2021
3.2.6 334,370 6/27/2021
3.2.5 200,508 4/21/2021
3.2.4 2,543,283 11/2/2020
3.2.3 438,215 10/13/2020
3.2.2 289,392 9/30/2020
3.2.1 106,846 9/23/2020
3.2.0 240,029 9/16/2020
3.1.2 1,400,422 7/22/2020
3.1.1 3,829,007 1/29/2020
3.1.0 814,605 12/16/2019
3.1.0-rc1.final 31,698 12/6/2019
3.0.1 107,663 12/4/2019
3.0.0 223,038 11/18/2019
3.0.0-rc3.final 34,581 11/7/2019
3.0.0-rc2.final 5,867 11/5/2019
3.0.0-rc1.final 140,820 10/6/2019
2.2.6 1,413,324 10/15/2019
2.2.0 4,055,837 2/7/2019
2.1.4 2,027,169 11/30/2018
2.1.2 1,127,235 9/4/2018
2.1.1 691,958 7/7/2018
2.1.0 202,038 7/11/2018
2.0.1 849,832 11/26/2017
2.0.0.1 60,786 10/27/2017
2.0.0 294,852 9/19/2017
1.1.2 270,158 5/6/2017
1.1.0 43,736 11/29/2016
1.0.1 17,064 10/29/2016
1.0.0 17,925 8/5/2016