Description

dotConnect for MySQL is a high-performance ORM enabled data provider for MySQL that builds on ADO.NET technology to present a complete solution for developing MySQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.

Our ADO.NET MySQL provider supports a wide range of MySQL-specific features, such as secure SSL and SSH connections, embedded server, compression protocol, HTTP tunneling and others.

Advanced Visual Studio Integration with MySQL
dotConnect for MySQL provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.

MySQL ADO.NET Provider supports advanced Visual Studio integration (DDEX) and provides convenient visual component editors to simplify component tweaking.

ADO.NET Provider with .NET Core and Entity Framework Support
dotConnect for MySQL was the first MySQL database provider to support .NET Core and Entity Framework Core, and we work hard to support new platforms and development technologies as soon as they are released.

MySQL support: from 3.23 to 8.0, Percona, and MariaDB
Visual Studio support: 2008 – 2019
Platforms support:
.NET 5.0, 6.0 compatibility
macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support
Windows 11 is supported
Visual Studio 2022 version 17.2 is supported.
Full .NET Framework 2.0 – 4.8
.NET Core 1.x, 2.x, and 3.0
.NET Compact Framework 2.0 and above
Mono 2.0 and above

Enhanced ORM Support
dotConnect for MySQL offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our MySQL ADO.NET Provider supports the following ORMs:

Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, 3.x, 5.0, and 6.0
NHibernate
LinqConnect
Dapper

v9.4.190 27-Dec-24

.NET 9 compatibility
Supported Visual Studio 2022 version 17.13 Preview
Added confirmation for the execution of stored procedures and functions in the DataSet Wizard
Fixed an issue with applying the license key on Red Hat-based Linux systems (Red Hat 9, AlmaLinux 9, Rocky Linux 9) when the system-wide cryptographic policy was set to DEFAULT
Fixed an issue with the missing Name and Owner properties in the DbCommandBase class within .NET Standard 2.0 compliant assemblies

Entity Framework support

Supported Entity Framework Core 9
Updated support for Entity Framework Core 8 to version 8.0.11
Updated support for Entity Framework Core 6 to version 6.0.36
Updated support for Entity Framework 6 (EF6) to version 6.5.1
Supported the SQL translation of TimeSpan.Milliseconds used in LINQ queries in EF Core
Supported the SQL translation of TimeSpan.Microseconds used in LINQ queries in EF Core 8 or higher

Entity Developer

.NET 9 has been added to the list of available Target Framework versions in the Create Model Wizard and Model Settings for EF and EF Core models
Added the "Nullable Reference Types" property to C# Data Transfer Object templates to control whether C# 8 nullable and non-nullable reference types should be generated
Fixed an issue with incorrect One-to-One relation multiplicity in EF Core models
Fixed a bug with the incorrect detection of two unique indexes on the same column in the Update From Database wizard for EF Core models
Fixed an error with code generation for stored procedures when Pluralization=Unchanged in the Model naming rules of the LinqConnect model

Additional Information