Microting.EntityFrameworkCore.MySql

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.

DISCLAIMER!!!

This is a fast moving version of Pomelo.EntityFrameworkCore.MySql intented to follow .net release cycle closely! There are no intentions for this package to implement new features. Feature requests needs to be directed at the originating Github repository

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
  • Microting.EntityFrameworkCore.MySql.Json.Microsoft
  • Microting.EntityFrameworkCore.MySql.Json.Newtonsoft
• Spatial support
  • Microting.EntityFrameworkCore.MySql.NetTopologySuite
• Other Packages
  • MySqlConnector
  • Microsoft.EntityFrameworkCore

License

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

Feedback

Checkout the originating Github repository before filing any new issues.

Bug reports and contributions are welcome at our GitHub repository.