Pomelo.EntityFrameworkCore.MySql
7.0.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
<PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="7.0.0" />
paket add Pomelo.EntityFrameworkCore.MySql --version 7.0.0
#r "nuget: Pomelo.EntityFrameworkCore.MySql, 7.0.0"
// 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
andSystem.Text.Json
) - Spatial support
- High performance
Related Packages
- JSON support
- Spatial support
- Other Packages
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 | Versions |
---|---|
.NET | net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows |
-
net6.0
- Microsoft.EntityFrameworkCore.Relational (>= 7.0.2)
- MySqlConnector (>= 2.2.5)
-
net7.0
- Microsoft.EntityFrameworkCore.Relational (>= 7.0.2)
- MySqlConnector (>= 2.2.5)
NuGet packages (567)
Showing the top 5 NuGet packages that depend on Pomelo.EntityFrameworkCore.MySql:
Package | Downloads |
---|---|
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite |
|
Microting.eForm
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 (106)
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
|
|
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 | 27,908 | 1/16/2023 |
7.0.0-silver.1 | 41,396 | 12/14/2022 |
7.0.0-alpha.1 | 64,191 | 11/16/2022 |
6.0.2 | 2,697,107 | 7/24/2022 |
6.0.1 | 3,007,685 | 1/22/2022 |
6.0.0 | 1,362,639 | 11/9/2021 |
6.0.0-rc.2 | 35,748 | 11/9/2021 |
6.0.0-rc.1 | 2,061 | 11/9/2021 |
6.0.0-preview.7 | 13,603 | 10/7/2021 |
6.0.0-preview.6 | 817 | 10/4/2021 |
6.0.0-preview.5 | 17,649 | 6/27/2021 |
6.0.0-preview.4 | 13,622 | 5/25/2021 |
5.0.4 | 505,107 | 1/22/2022 |
5.0.3 | 360,084 | 11/9/2021 |
5.0.2 | 480,784 | 10/4/2021 |
5.0.1 | 1,419,936 | 6/27/2021 |
5.0.0 | 1,298,500 | 4/28/2021 |
5.0.0-beta.2 | 5,155 | 4/28/2021 |
5.0.0-beta.1 | 61,002 | 4/22/2021 |
5.0.0-alpha.2 | 1,311,467 | 11/12/2020 |
5.0.0-alpha.1 | 67,899 | 11/5/2020 |
3.2.7 | 410,843 | 10/4/2021 |
3.2.6 | 289,711 | 6/27/2021 |
3.2.5 | 182,370 | 4/21/2021 |
3.2.4 | 2,382,060 | 11/2/2020 |
3.2.3 | 418,485 | 10/13/2020 |
3.2.2 | 262,924 | 9/30/2020 |
3.2.1 | 103,351 | 9/23/2020 |
3.2.0 | 221,195 | 9/16/2020 |
3.1.2 | 1,282,771 | 7/22/2020 |
3.1.1 | 3,633,544 | 1/29/2020 |
3.1.0 | 779,608 | 12/16/2019 |
3.1.0-rc1.final | 31,570 | 12/6/2019 |
3.0.1 | 104,988 | 12/4/2019 |
3.0.0 | 212,750 | 11/18/2019 |
3.0.0-rc3.final | 33,915 | 11/7/2019 |
3.0.0-rc2.final | 5,786 | 11/5/2019 |
3.0.0-rc1.final | 137,382 | 10/6/2019 |
2.2.6 | 1,275,218 | 10/15/2019 |
2.2.0 | 3,816,794 | 2/7/2019 |
2.1.4 | 1,963,195 | 11/30/2018 |
2.1.2 | 1,093,614 | 9/4/2018 |
2.1.1 | 673,175 | 7/7/2018 |
2.1.0 | 198,046 | 7/11/2018 |
2.0.1 | 825,158 | 11/26/2017 |
2.0.0.1 | 60,048 | 10/27/2017 |
2.0.0 | 287,268 | 9/19/2017 |
1.1.2 | 246,801 | 5/6/2017 |
1.1.0 | 43,443 | 11/29/2016 |
1.0.1 | 16,952 | 10/29/2016 |
1.0.0 | 16,445 | 8/5/2016 |