Pomelo.EntityFrameworkCore.MySql 9.0.0-preview.1

This is a prerelease version of Pomelo.EntityFrameworkCore.MySql.
dotnet add package Pomelo.EntityFrameworkCore.MySql --version 9.0.0-preview.1
NuGet\Install-Package Pomelo.EntityFrameworkCore.MySql -Version 9.0.0-preview.1
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.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Pomelo.EntityFrameworkCore.MySql --version 9.0.0-preview.1
#r "nuget: Pomelo.EntityFrameworkCore.MySql, 9.0.0-preview.1"
#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=9.0.0-preview.1&prerelease

// Install Pomelo.EntityFrameworkCore.MySql as a Cake Tool
#tool nuget:?package=Pomelo.EntityFrameworkCore.MySql&version=9.0.0-preview.1&prerelease

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 (759)

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 1,701 2/28/2024
8.0.2 58,305 3/16/2024
8.0.1 93,665 2/28/2024
8.0.0 218,380 2/13/2024
8.0.0-beta.2 355,785 11/18/2023
8.0.0-beta.1 35,352 9/29/2023
7.0.0 7,332,515 1/16/2023
7.0.0-silver.1 205,884 12/14/2022
7.0.0-alpha.1 155,256 11/16/2022
6.0.3 5,093 3/16/2024
6.0.2 10,843,732 7/24/2022
6.0.1 5,715,429 1/22/2022
6.0.0 2,531,296 11/9/2021
6.0.0-rc.2 59,574 11/9/2021
6.0.0-rc.1 2,613 11/9/2021
6.0.0-preview.7 20,765 10/7/2021
6.0.0-preview.6 913 10/4/2021
6.0.0-preview.5 25,334 6/27/2021
6.0.0-preview.4 15,115 5/25/2021
5.0.4 987,339 1/22/2022
5.0.3 509,535 11/9/2021
5.0.2 657,864 10/4/2021
5.0.1 1,929,793 6/27/2021
5.0.0 1,711,382 4/28/2021
5.0.0-beta.2 5,355 4/28/2021
5.0.0-beta.1 75,392 4/22/2021
5.0.0-alpha.2 1,516,133 11/12/2020
5.0.0-alpha.1 74,548 11/5/2020
3.2.7 860,686 10/4/2021
3.2.6 456,386 6/27/2021
3.2.5 239,467 4/21/2021
3.2.4 2,859,330 11/2/2020
3.2.3 471,453 10/13/2020
3.2.2 350,667 9/30/2020
3.2.1 115,983 9/23/2020
3.2.0 266,525 9/16/2020
3.1.2 1,567,325 7/22/2020
3.1.1 4,141,560 1/29/2020
3.1.0 896,786 12/16/2019
3.1.0-rc1.final 31,851 12/6/2019
3.0.1 117,253 12/4/2019
3.0.0 241,895 11/18/2019
3.0.0-rc3.final 39,189 11/7/2019
3.0.0-rc2.final 6,004 11/5/2019
3.0.0-rc1.final 150,624 10/6/2019
2.2.6 1,632,656 10/15/2019
2.2.0 4,536,930 2/7/2019
2.1.4 2,236,432 11/30/2018
2.1.2 1,207,499 9/4/2018
2.1.1 742,979 7/7/2018
2.1.0 211,742 7/11/2018
2.0.1 1,017,947 11/26/2017
2.0.0.1 64,243 10/27/2017
2.0.0 329,050 9/19/2017
1.1.2 308,744 5/6/2017
1.1.0 58,796 11/29/2016
1.0.1 17,698 10/29/2016
1.0.0 23,128 8/5/2016