pomelo-debug - Pomelo.EntityFrameworkCore.MySql 9.0.0-preview.2.ci.20240426121436.debug+sha.99e7920
Pomelo's MySQL database provider for Entity Framework Core.
PM> Install-Package Pomelo.EntityFrameworkCore.MySql -Version 9.0.0-preview.2.ci.20240426121436.debug -Source https://www.myget.org/F/pomelo-debug/api/v3/index.json
> nuget.exe install Pomelo.EntityFrameworkCore.MySql -Version 9.0.0-preview.2.ci.20240426121436.debug -Source https://www.myget.org/F/pomelo-debug/api/v3/index.json
> dotnet add package Pomelo.EntityFrameworkCore.MySql --version 9.0.0-preview.2.ci.20240426121436.debug --source https://www.myget.org/F/pomelo-debug/api/v3/index.json
<PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="9.0.0-preview.2.ci.20240426121436.debug" />
Copy to clipboard
source https://www.myget.org/F/pomelo-debug/api/v3/index.json
nuget Pomelo.EntityFrameworkCore.MySql ~> 9.0.0-preview.2.ci.20240426121436.debug
Copy to clipboard
> choco install Pomelo.EntityFrameworkCore.MySql --version 9.0.0-preview.2.ci.20240426121436.debug --source https://www.myget.org/F/pomelo-debug/api/v2
Import-Module PowerShellGet
Register-PSRepository -Name "pomelo-debug" -SourceLocation "https://www.myget.org/F/pomelo-debug/api/v2"
Install-Module -Name "Pomelo.EntityFrameworkCore.MySql" -RequiredVersion "9.0.0-preview.2.ci.20240426121436.debug" -Repository "pomelo-debug" -AllowPreRelease
Copy to clipboard
Pomelo.EntityFrameworkCore.MySql
Pomelo.EntityFrameworkCore.MySql
is the most popular Entity Framework Core provider for MySQL compatible databases. It supports EF Core up to its latest version and uses MySqlConnector for high-performance database server communication.
Compatibility
Dependencies
The following versions of MySqlConnector, EF Core, .NET (Core), .NET Standard and .NET Framework are compatible with published releases of Pomelo.EntityFrameworkCore.MySql
:
Release | Branch | MySqlConnector | EF Core | .NET (Core) | .NET Standard | .NET Framework |
---|---|---|---|---|---|---|
9.0.0- preview.1 |
main | >= 2.3.5 | 9.0.0- preview.1 |
8.0+ | - | - |
8.0.2 | 8.0-maint | >= 2.3.5 | 8.0.2 | 8.0+ | - | - |
7.0.0 | 7.0-maint | >= 2.2.5 | 7.0.x | 6.0+ | - | - |
6.0.3 | 6.0-maint | >= 2.1.2 | 6.0.x | 6.0+ | - | - |
5.0.4 | 5.0-maint | >= 1.3.13 | 5.0.x | 3.0+ | 2.1 | - |
3.2.7 | 3.2-maint | >= 0.69.10 < 1.0.0 | 3.1.x | 2.0+ | 2.0 | 4.6.1+ |
Packages
- Pomelo.EntityFrameworkCore.MySql
- Pomelo.EntityFrameworkCore.MySql.Json.Microsoft
- Pomelo.EntityFrameworkCore.MySql.Json.Newtonsoft
- Pomelo.EntityFrameworkCore.MySql.NetTopologySuite
Supported Database Servers and Versions
Pomelo.EntityFrameworkCore.MySql
is tested against all actively maintained versions of MySQL
and MariaDB
. Older versions (e.g. MySQL 5.7) and other server implementations (e.g. Amazon Aurora) are usually compatible to a high degree as well, but are not tested as part of our CI.
Officially supported versions are:
- MySQL 8.0
- MariaDB 11.3
- MariaDB 11.2
- MariaDB 11.1
- MariaDB 11.0
- MariaDB 10.11 (LTS)
- MariaDB 10.6 (LTS)
- MariaDB 10.5 (LTS)
- MariaDB 10.4 (LTS)
Schedule and Roadmap
Milestone | Status | Release Date |
---|---|---|
9.0.0-preview.1 | Released | 2024-02-28 (see #1841) |
8.0.2 | Released | 2024-03-16 |
7.0.0 | Released | 2023-01-16 |
6.0.3 | Released | 2024-03-16 |
5.0.4 | Released | 2022-01-22 |
3.2.7 | Released | 2021-10-04 |
Nightly Builds
To use nightly builds from our Azure DevOps feed, add a NuGet.config
file to your solution root with the following content and enable prereleases:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<packageSources>
<add key="pomelo-nightly" value="https://pkgs.dev.azure.com/pomelo-efcore/Pomelo.EntityFrameworkCore.MySql/_packaging/pomelo-efcore-public/nuget/v3/index.json" />
<add key="nuget.org" value="https://api.nuget.org/v3/index.json" />
</packageSources>
</configuration>
Feeds
Feeds that contain optimized (Release
configuration) builds:
https://pkgs.dev.azure.com/pomelo-efcore/Pomelo.EntityFrameworkCore.MySql/_packaging/pomelo-efcore-public/nuget/v3/index.json
https://www.myget.org/F/pomelo/api/v3/index.json
Feeds that contain debugging enabled unoptimized (Debug
configuration) builds:
https://pkgs.dev.azure.com/pomelo-efcore/Pomelo.EntityFrameworkCore.MySql/_packaging/pomelo-efcore-debug/nuget/v3/index.json
https://www.myget.org/F/pomelo-debug/api/v3/index.json
The AZDO nupkg
packages always contain .pdb
files.
The MyGet nupkg
packages only contain .pdb
files for their debug builds. For optimized builds, the symbols are packed in a snupkg
file and are available via the https://www.myget.org/F/pomelo/api/v2/symbolpackage/
symbol server URL.
All .pdb
files use Source Link.
Getting Started
1. Project Configuration
Ensure that your .csproj
file contains the following reference:
<PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="8.0.2" />
2. Services Configuration
Add Pomelo.EntityFrameworkCore.MySql
to the services configuration in your the Startup.cs
file of your ASP.NET Core project:
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, 36));
// 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()
);
}
}
View our Configuration Options Wiki Page for a list of common options.
3. Sample Application
Check out our Integration Tests for an example repository that includes an ASP.NET Core MVC Application.
There are also many complete and concise console application samples posted in the issue section (some of them can be found by searching for Program.cs
).
4. Read the EF Core Documentation
Refer to Microsoft's EF Core Documentation for detailed instructions and examples on using EF Core.
Scaffolding / Reverse Engineering
Use the EF Core tools to execute scaffolding commands:
dotnet ef dbcontext scaffold "Server=localhost;User=root;Password=1234;Database=ef" "Pomelo.EntityFrameworkCore.MySql"
Contribute
One of the easiest ways to contribute is to report issues, participate in discussions and update the wiki docs. You can also contribute by submitting pull requests with code changes and supporting tests.
We are always looking for additional core contributors. If you got a couple of hours a week and know your way around EF Core and MySQL, give us a nudge.
License
-
.NETFramework 8.0
- Microsoft.EntityFrameworkCore.Relational (>= 9.0.0-preview.1.24081.2 && <= 9.0.0-preview.1.999999)
- MySqlConnector (>= 2.3.5)
- .NETFramework 8.0: 8.0.0.0
OwnersLauXjpn |
AuthorsLaurents Meyer, Caleb Lloyd, Yuko Zheng |
Project URLhttps://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql |
LicenseUnknown |
Tagspomelo mysql mariadb Entity Framework Core entity-framework-core ef efcore ef core orm sql |
Info0 total downloads |
0 downloads for version 9.0.0-preview.2.ci.20240426121436.debug+sha.99e7920 |
Download (338.69 KB) |
Found on the current feed only |