Devart.Data.MySql.EFCore 9.3.21.8

Prefix Reserved
dotnet add package Devart.Data.MySql.EFCore --version 9.3.21.8                
NuGet\Install-Package Devart.Data.MySql.EFCore -Version 9.3.21.8                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Devart.Data.MySql.EFCore" Version="9.3.21.8" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Devart.Data.MySql.EFCore --version 9.3.21.8                
#r "nuget: Devart.Data.MySql.EFCore, 9.3.21.8"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Devart.Data.MySql.EFCore as a Cake Addin
#addin nuget:?package=Devart.Data.MySql.EFCore&version=9.3.21.8

// Install Devart.Data.MySql.EFCore as a Cake Tool
#tool nuget:?package=Devart.Data.MySql.EFCore&version=9.3.21.8                

dotConnect for MySQL

dotConnect for MySQL is a high-performance ORM enabled data provider for MySQL 8.0+ including Embedded servers (starting with 4.1), MariaDB, Amazon RDS, Amazon Aurora, Azure MySQL, Percona that builds on ADO.NET technology.

The provider works with .NET Frameworks 4.6+, .NET Core 1.0+, .NET 5+. The product is compatible with ADO.NET Entity Framework v1 - v6 and Entity Framework (EF) Core 8+.

It supports a wide range of MySQL-specific features, such as secure SSL and SSH connections, compression protocol, HTTP tunneling and others.

More information at dotConnect for MySQL.

Installation


For projects, using Entity Framework Core 1, 3, 5, 6, 7, 8 with MySQL, install this package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.MySql.EFCore

For projects, using Entity Framework Core 1.1, for which you use database-first approach and generate an Entity Framework Core mapping via the Scaffold-DbContext command of Package Manager Console, you need to install the Devart.Data.MySql.EFCore.Design package.

For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.MySql.EF6 package.

There also are Visual Studio extensions for earlier Visual Studio versions. If you use some other tool than Visual Studio, you can get NuGet packages with the nuget.exe console tool.

To activate your license, please download dotConnect for MySQL from our website. The Professional editions of dotConnect for MySQL include Entity Developer, a comprehensive visual ORM designer, enhancing the development experience with intuitive design and management of ORM models.

Compatibility


The following table show which version of this package to use with which version of frameworks.

Frameworks Version support
Entity Framework Core 8, 7, 6, 5, 3, 2, 1
.NET 8, 7, 6, 5
.NET Core 3, 2, 1
.NET Framework 4.8, 4.7, 4.6

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": "User Id=root;Password=mypassword;Host=127.0.0.1;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.

License

dotConnect for MySQL is available in several editions. See pricing options for ordering.

Support Area

Documentation Request form Feedback page Product history

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (4)

Showing the top 4 NuGet packages that depend on Devart.Data.MySql.EFCore:

Package Downloads
Devart.Data.MySql.EFCore.Design

dotConnect for MySQL is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with advanced support for ORMs, such as Entity Framework and EF Core, and offers a complete solution for developing DB-related applications and web sites.

Devart.Data.MySql.EFCore.NetTopologySuite

dotConnect for MySQL is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with advanced support for ORMs, such as Entity Framework and EF Core, and offers a complete solution for developing DB-related applications and web sites.

BizDoc.Core.MySql

MySql storage for BizDoc

BizDoc.Storage.MySql

MySql storage for BizDoc

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
9.3.21.8 922 6/6/2024
9.3.21.7 124 6/6/2024
9.3.21 229 6/6/2024
9.3.20.8 373 5/30/2024
9.3.20.7 134 5/30/2024
9.3.20 220 5/30/2024
9.3.10.8 1,681 1/18/2024
9.3.10.7 1,003 1/18/2024
9.3.10 924 1/18/2024
9.2.0.7 2,384 11/17/2023
9.2.0 1,491 11/17/2023
9.1.151.7 4,672 6/7/2023
9.1.151 1,828 6/7/2023
9.1.134.7 4,496 3/4/2023
9.1.134 2,219 3/4/2023
9.0.0 110,527 7/1/2022
8.21.2066 25,494 1/26/2022
8.20.2042 58,265 12/21/2021
8.19.2014 4,714 11/9/2021
8.19.2001 3,095 10/21/2021
8.19.1985 3,651 9/28/2021
8.19.1944 2,837 7/30/2021
8.19.1930 2,698 7/8/2021
8.19.1905 22,727 6/3/2021
8.19.1866 4,563 4/9/2021
8.19.1860 2,404 4/1/2021
8.19.1836 2,701 2/18/2021
8.19.1812 2,819 1/14/2021
8.19.1792 2,635 12/17/2020
8.19.1782 2,558 12/3/2020
8.18.1759 119,335 10/29/2020
8.18.1739 4,325 10/1/2020
8.18.1730 4,508 9/17/2020
8.17.1696 4,571 7/30/2020
8.17.1686 5,464 7/16/2020
8.17.1666 4,073 6/17/2020
8.17.1612 22,155 4/2/2020
8.17.1583 22,437 2/20/2020
8.16.1541 3,045 12/23/2019
8.15.1519 95,722 11/21/2019
8.15.1504 3,942 10/31/2019
8.15.1499 2,304 10/24/2019
8.14.1470 3,351 9/13/2019
8.13.1437 3,668 7/25/2019
8.13.1422 2,795 7/4/2019
8.13.1402 2,897 6/6/2019
8.13.1366 26,082 4/12/2019
8.12.1357 3,993 3/28/2019
8.12.1328 3,095 2/14/2019
8.12.1307 10,079 1/10/2019
8.12.1278 4,017 11/29/2018
8.12.1253 3,632 10/25/2018
8.12.1229 8,684 9/20/2018
8.12.1216 3,026 8/31/2018
8.12.1202 5,169 8/10/2018
8.12.1190 4,684 7/19/2018
8.11.1172 3,554 6/22/2018
8.10.1152 3,295 5/25/2018
8.10.1134 3,261 4/27/2018
8.10.1115 3,313 3/30/2018
8.10.1086 3,394 2/15/2018
8.10.1061 2,980 1/11/2018
8.10.1031 2,805 11/23/2017
8.10.1013 2,772 10/30/2017
8.9.980 3,686 9/7/2017
8.9.958 3,171 8/4/2017
8.9.946 2,990 7/14/2017
8.9.931 2,884 6/23/2017
8.9.912 2,956 5/25/2017