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

9.3.104 08-Nov-24

Supported Visual Studio 2022 version 17.12 Preview
Added support for fractional seconds in Time, DateTime, and TimeStamp types within the MySqlLoader class
Fixed an issue with integration in Visual Studio 2015 and earlier versions
Fixed the DataSet Wizard crash in Visual Studio 2022
Fixed a design-time bug with the MySqlDataTable Tasks interface element in Visual Studio 2022
Fixed an issue with reopening the connection when using the ChangeDatabase() method
Entity Framework support

Updated support for Entity Framework Core 8 to version 8.0.10
Updated support for Entity Framework Core 6 to version 6.0.35
Added support for generating LEFT JOIN LATERAL and CROSS JOIN LATERAL when translating EF Core LINQ queries for MySQL 8.0.14 and above
Entity Developer

Fixed an issue where the Update From Database Wizard reset navigation property names in EF Core models

Additional Information