dotConnect for MySQL Documentation

MySQL server

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. dotConnect for MySQL supports Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon RDS for Aurora.

Framework Compatibility

The provider works with .NET Frameworks 2.0, 3.0, 3.5, 4.0, 4.5, 4.6, 4.7, or 4.8, .NET 5.0, and .NET Compact Framework. dotConnect for MySQL supports Mono version 2.0 and above. The product is compatible with ADO.NET Entity Framework v1 - v6 and Entity Framework Core 1.1.5, 2.2.6, 3.1.10, and 5.0. (MySQL server 5.0 or higher is required for Entity Framework).

Additionally, dotConnect for MySQL provides .NET Standard 1.3 compatible assemblies, which are compatible with .NET Core 1.x and .NET Framework 4.6 and higher, and .NET Standard 2.0 compatible assemblies, compatible with .NET Core 2.0 and higher and .NET Framework 4.6.1 and higher. There are also .NET Standard 2.1 compatible assemblies for Entity Framework 6.3 and Entity Framework Core 3, compatible with .NET Core 3.x and .NET 5.

IDE Compatibility

dotConnect for MySQL can be used with following integrated development environments:

  • Visual Studio 2019 release and preview
  • Visual Studio 2017
  • Visual Studio 2015
  • Visual Studio 2015
  • Visual Studio 2013
  • Visual Studio 2012
  • Visual Studio 2010
  • Visual Studio 2008
  • Embarcadero Delphi Prism
  • CodeGear RAD Studio 2007
  • Visual Studio Code

There are some limitations in Express Editions of Visual Studio. The following features are not available: provider add-in, automatic toolbox components registration and Server Explorer integration. As an exclusion, Visual Web Developer 2008 and 2010 supports Server Explorer features.

RAD Studio 2007 is supported in run time only as these environments have no WinForms designers.

Since dotConnect for MySQL is available as NuGet packages, it supports Visual Studio Code. Visual Studio Code is a cross-platform code editor, developed by Microsoft.

Unlike Microsoft Visual Studio, Visual Studio Code does not support design-time features. Thus, there are no integration of dotConnect for MySQL to Visual Studio Code, and no design-time features or wizards or other tools, etc.

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.

dbForge Fusion for MySQL Compatibility

When used in Visual Studio 2008, this version of provider is compatible with dbForge Fusion 3.50 and higher.