Pomelo.EntityFrameworkCore.MySql 8.0.2

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.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.
paket add Pomelo.EntityFrameworkCore.MySql --version 8.0.2
#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.
// Install Pomelo.EntityFrameworkCore.MySql as a Cake Addin
#addin nuget:?package=Pomelo.EntityFrameworkCore.MySql&version=8.0.2

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

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 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (740)

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组件,第三方组件封装,第三方业务接口封装,配套代码生成模板,权限等组成。

Pomelo.EntityFrameworkCore.MySql.NetTopologySuite

NetTopologySuite support for Pomelo's MySQL provider for Entity Framework Core.

GitHub repositories (118)

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
btcpayserver/btcpayserver
Accept Bitcoin payments. Free, open-source & self-hosted, Bitcoin payment processor.
Version Downloads Last updated
9.0.0-preview.1 4,086 2/28/2024
8.0.2 319,871 3/16/2024
8.0.1 145,799 2/28/2024
8.0.0 451,655 2/13/2024
8.0.0-beta.2 424,255 11/18/2023
8.0.0-beta.1 36,649 9/29/2023
7.0.0 8,102,583 1/16/2023
7.0.0-silver.1 210,789 12/14/2022
7.0.0-alpha.1 159,194 11/16/2022
6.0.3 25,588 3/16/2024
6.0.2 11,548,593 7/24/2022
6.0.1 5,852,599 1/22/2022
6.0.0 2,591,139 11/9/2021
6.0.0-rc.2 59,667 11/9/2021
6.0.0-rc.1 2,692 11/9/2021
6.0.0-preview.7 21,299 10/7/2021
6.0.0-preview.6 916 10/4/2021
6.0.0-preview.5 25,603 6/27/2021
6.0.0-preview.4 15,169 5/25/2021
5.0.4 1,011,456 1/22/2022
5.0.3 516,932 11/9/2021
5.0.2 669,077 10/4/2021
5.0.1 1,952,188 6/27/2021
5.0.0 1,767,059 4/28/2021
5.0.0-beta.2 5,357 4/28/2021
5.0.0-beta.1 75,865 4/22/2021
5.0.0-alpha.2 1,523,702 11/12/2020
5.0.0-alpha.1 75,091 11/5/2020
3.2.7 879,462 10/4/2021
3.2.6 465,565 6/27/2021
3.2.5 241,213 4/21/2021
3.2.4 2,880,435 11/2/2020
3.2.3 474,167 10/13/2020
3.2.2 352,583 9/30/2020
3.2.1 116,949 9/23/2020
3.2.0 267,631 9/16/2020
3.1.2 1,581,000 7/22/2020
3.1.1 4,159,043 1/29/2020
3.1.0 901,858 12/16/2019
3.1.0-rc1.final 31,866 12/6/2019
3.0.1 118,312 12/4/2019
3.0.0 242,943 11/18/2019
3.0.0-rc3.final 39,533 11/7/2019
3.0.0-rc2.final 6,010 11/5/2019
3.0.0-rc1.final 150,778 10/6/2019
2.2.6 1,643,265 10/15/2019
2.2.0 4,559,528 2/7/2019
2.1.4 2,246,260 11/30/2018
2.1.2 1,211,227 9/4/2018
2.1.1 745,956 7/7/2018
2.1.0 212,286 7/11/2018
2.0.1 1,027,020 11/26/2017
2.0.0.1 64,421 10/27/2017
2.0.0 331,341 9/19/2017
1.1.2 312,033 5/6/2017
1.1.0 59,711 11/29/2016
1.0.1 17,710 10/29/2016
1.0.0 24,348 8/5/2016