👁 Image
Pomelo.EntityFrameworkCore.MySql 9.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 and System.Text.Json)
• Spatial support
• High performance

Related Packages

• JSON support
  • Pomelo.EntityFrameworkCore.MySql.Json.Microsoft
  • Pomelo.EntityFrameworkCore.MySql.Json.Newtonsoft
• Spatial support
  • Pomelo.EntityFrameworkCore.MySql.NetTopologySuite
• Other Packages
  • MySqlConnector
  • Microsoft.EntityFrameworkCore

License

Pomelo.EntityFrameworkCore.MySql is released as open source under the MIT license.

Feedback

Bug reports and contributions are welcome at our GitHub repository.