Devart/Devart.Data.MySql.EFCorev10.1.33.10

More information here

Usage

This snippet directly configures a MySQL database connection for an Entity Framework Core DbContext using a connection string.

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     optionsBuilder.UseMySql(@"User Id=root;Password=mypassword;Host=127.0.0.1;Port=3306;");
  } 
}

Configuration Using MySqlConnection Instance

using Devart.Data.MySql;
...

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     var connection = new MySqlConnection();
     connection.Host = "127.0.0.1";
     connection.Port = 3306;
     connection.UserId = "root";
     connection.Password = "mypassword";
     optionsBuilder.UseMySql(connection);
  } 
}

ASP.NET Core and Blazor

Configuration File (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "Host=127.0.0.1;UserId=root;Password=mypassword;Port=3306;"
   }
}

DbContext Configuration:

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

    IConfigurationBuilder builder = new ConfigurationBuilder().AddJsonFile("appsettings.json");
    IConfiguration configuration = builder.Build();
    optionsBuilder.UseMySql(configuration.GetConnectionString("DefaultConnection"));
  } 
}

For more information about secure connections using SSL or SSH connections read at out documentation.

Key Features

• Direct Mode: Allows your application to work with MySQL directly, without involving MySQL client library.
• ASP.NET Core: Supports ASP.NET Core Identity.
• Performance: Uses many MySQL-specific performance features & optimizations to ensure the highest performance.
• Monitoring: Allows per-component tracing of database events with a free dbMonitor application.
• Security: Supports various encryption ciphers, SSL and SSH connections, etc.
• Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Related Packages

• Devart.Data.MySql
• Devart.Data.MySql.EF6

Support Area

• Documentation
• Request form
• Feedback page
• Product history