dotConnect for MySQL Compatibility
Database Compatibility
dotConnect for MySQL supports MySQL server versions 8.0, 5.7, 5.6, 5.5, 5.4, 5.1, 5.0, 4.1, 4.0 and 3.23 including Embedded servers (starting with 4.1), 64-bit MySQL servers, Percona, and MariaDB (version 11, 10, 5). dotConnect for MySQL supports Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon RDS for Aurora.
Framework Compatibility
The provider works with:
- Microsoft .NET Framework 2.0, 3.0, 3.5, 4.0, 4.5, 4.6, 4.7, and 4.8
- Microsoft .NET Core 1.x, 2.x, 3.x
- Microsoft .NET 5.0, 6.0, 7.0, and 8.0
- Microsoft .NET Compact Framework 2.0 and above
- Mono version 2.0 and above
dotConnect for MySQL is compatible with ADO.NET Entity Framework v1 - v6 and Entity Framework Core 1.x, 2.x, 3.1, 5.0, 6.0, 7.0, and 8.0. (MySQL server 5.0 or higher is required for Entity Framework).
IDE Compatibility
dotConnect for MySQL can be used with the following development environments:
- Microsoft Visual Studio 2022 release and preview
- Microsoft Visual Studio 2019
- Microsoft Visual Studio 2017
- Microsoft Visual Studio 2015
- Microsoft Visual Studio 2013
- Microsoft Visual Studio 2012
- Microsoft Visual Studio 2010
- Microsoft Visual Studio 2008
- Embarcadero Delphi Prism
- CodeGear RAD Studio 2007
There are some limitations in Express Editions of Visual Studio. The following features are not available: provider add-in, automatic toolbox components registration and DDEX integration. As an exception, Visual Web Developer 2008 and 2010 supports DDEX features.
dotConnect for MySQL supports Visual Studio Lightswitch 2011 and 2012. See our tutorial: How to Connect Visual Studio LightSwitch to MySQL with dotConnect for MySQL Data Provider.
RAD Studio 2007 is supported at run-time only, as these environments have no WinForms designers.
Devart Data Providers Compatibility
Since Devart data providers use a common assembly (Devart.Data.dll), it is necessary to make sure that all installed data providers are compatible.
dotConnect for MySQL can be used together with dotConnect Universal that provides universal access to different databases via the same code.