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 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. |
-
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 (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
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 |