MySQL Connector/NET Developer Guide
There are two Connector/NET release series described in this guide:
MySQL Connector/NET 8.0 is a continuation of Connector/NET 7.0, but now named to synchronize the first digit of the version number with the (highest) MySQL server version it supports. This version combines the functionality of the previous Connector/NET release series, including support for X Protocol.
MySQL Connector/NET 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, and 5.6. Please upgrade to MySQL Connector/NET 8.0.
MySQL Connector/NET 6.10 has reached end-of-service. It includes Entity Framework Core support and enables compression in the .NET Core driver implementation. Provides expanded cross-platform support to Linux and macOS when using .NET Core.
Secure connections using the TLSv1.2 protocol require a minimum version of either Connector/NET 6.10.4 or Connector/NET 8.0.11 (Commercial and Community Editions). In addition, the Microsoft Windows or Microsoft Windows Server host must support TLSv1.2 (enabled manually or by default). Connections made using Windows named pipes or shared memory do not support the TLSv1.2 protocol. For general guidance about configuring the server and clients for encrypted connections, see Configuring MySQL to Use Encrypted Connections.
.NET 5.0, .NET Core 3.1, and .NET Framework 4.8 (Windows only) include support for the TLSv1.3 protocol. Be sure to confirm that the operating system running your application also supports TLSv1.3 before using it exclusively for connections.
The following table shows the versions of ADO.NET, .NET (Core and Framework), and MySQL Server that are supported or required by MySQL Connector/NET.
Table 2.1 Connector/NET Requirements for Related Products
| Connector/NET Version | ADO.NET Version | .NET Version Required | MySQL Server | Supported? |
|---|---|---|---|---|
| 8.0 | 2.x+ |
|
8.0, 5.7, 5.6 | Yes |
| 6.10 archive version | 2.x+ |
|
8.0, 5.7, 5.6 | Upgrade to 8.0 |
The following versions of Connector/NET are no longer supported:
MySQL Connector/NET 7.0 includes support for the X Protocol (development milestone releases only).
MySQL Connector/NET 6.9 includes new features such as a MySQL web personalization, sitemap, and simple membership providers. It also includes support for MySQL for Visual Studio 1.2 (or higher).
Connector/NET 6.8 includes new features such as Entity Framework 6 support, added idempotent script for Entity Framework 6 migrations, changed EF migration history table to use a single column as primary key, removed installer validation when MySQL for Visual Studio is installed, and support for MySQL for Visual Studio 1.1.
This version of Connector/NET is no longer supported.
Connector/NET 6.7 includes new features such as Entity Framework 5 support, built-in Load Balancing (to be used with a back end implementing either MySQL Replication or MySQL Clustering), a Memcached client (compatible with Innodb Memcached plugin) and support for Windows Runtime (WinRT) to write store apps. This version also removes all features related to Visual Studio Integration, which are provided in a separate product, MySQL for Visual Studio.
This version of Connector/NET is no longer supported.
Connector/NET 6.6 includes new features such as stored procedure debugging in Microsoft Visual Studio, support for pluggable authentication including the ability to write your own authentication plugins, Entity Framework 4.3 Code First support, and enhancements to partial trust support to allow hosting services to deploy applications without installing the Connector/NET library in the GAC.
This version of Connector/NET is no longer supported.
Connector/NET 6.5 includes new features such as interceptor classes for
exceptions and commands, support for the MySQL 5.6+ fractional
seconds feature, better partial-trust support, and better
IntelliSense, including auto-completion when editing stored
procedures or .mysql files.
This version of Connector/NET is no longer supported.
Connector/NET 6.4 includes new features such as support for Windows authentication (when connecting to MySQL Server 5.5+), table caching on the client side, simple connection fail-over support, and improved SQL generation from the Entity Framework provider.
This version of Connector/NET is no longer supported.
Connector/NET 6.3 includes new features such as integration with Visual Studio 2010, such as the availability of DDL T4 template for Entity Framework, and a custom MySQL SQL Editor. Other features include refactored transaction scope: Connector/NET now supports nested transactions in a scope where they use the same connection string.
This version of Connector/NET is no longer supported.
Connector/NET 6.2 includes new features such as a new logging system and client SSL certificates.
This version of Connector/NET is no longer supported.
Connector/NET 6.1 includes new features such as the MySQL Website Configuration Tool, and a Session State Provider.
This version of Connector/NET is no longer supported.
Connector/NET 6.0 includes support for UDF schema collection, Initial Entity Framework, and use of the traditional SQL Server buttons in Visual Studio for keys, indexes, and so on.
This version of Connector/NET is no longer supported.
Connector/NET 5.2 includes support for a new membership and role
providers, Compact Framework 2.0, a new stored procedure parser
and improvements to GetSchema. Connector/NET 5.2
also includes the Visual Studio Plugin as a standard installable
component.
This version of Connector/NET is no longer supported.
Connector/NET 5.1 includes support for a new membership and role
providers, Compact Framework 2.0, a new stored procedure parser
and improvements to GetSchema. Connector/NET 5.1
also includes the Visual Studio Plugin as a standard installable
component.
This version of Connector/NET is no longer supported.
Connector/NET 5.0 includes full support for the ADO.NET 2.0 interfaces and subclasses, includes support for the usage advisor and performance monitor (PerfMon) hooks.
This version of Connector/NET is no longer supported.
Connector/NET 1.0 includes full compatibility with the ADO.NET driver interface.
This version of Connector/NET is no longer supported.
The following table shows the .NET Framework version required and the MySQL server version supported by Connector/NET:
Table 2.2 Connector/NET Requirements for Related Products
| Connector/NET Version | ADO.NET Version Supported | .NET Framework Version Required | MySQL Server Version Supported | Currently Supported |
|---|---|---|---|---|
| 7.0 | 2.x+ | .NET Core 1.1 for VS 2015 / 2017; .NET Framework 4.5.x for VS 2013 / 2015 / 2017 | 5.7, 5.6 | No |
| 6.9 | 2.x+ | 3.5+ for VS 2008, 4.x+ for VS 2010 / 2012 / 2013, WinRT for VS 2012 / 2013 | 5.7, 5.6, 5.5 | No |
| 6.8 | 2.x+ | 3.5+ for VS 2008, 4.x+ for VS 2010 / 2012 / 2013, WinRT for VS 2012 / 2013 | 5.7, 5.6, 5.5, 5.1, 5.0 | No |
| 6.7 | 2.x+ | 2.x+ for VS 2008, 4.x+ for VS 2010 / 2012 / 2013, WinRT for VS 2012 / 2013 | 5.7, 5.6, 5.5, 5.1, 5.0 | No |
| 6.6 | 2.x+ | 2.x+ for VS 2008, 4.x+ for VS 2010 / 2012 / 2013 | 5.7, 5.6, 5.5, 5.1, 5.0 | No |
| 6.5 | 2.x+ | 2.x+ for VS 2008, 4.x+ for VS 2010 | 5.7, 5.6, 5.5, 5.1, 5.0 | No |
| 6.4 | 2.x+ | 2.x+, 4.x+ for VS 2010 | 5.6, 5.5, 5.1, 5.0 | No |
| 6.3 | 2.x+ | 2.x+, 4.x+ for VS 2010 | 5.6, 5.5, 5.1, 5.0 | No |
| 6.2 | 2.x+ | 2.x+ | 5.6, 5.5, 5.1, 5.0, 4.1 | No |
| 6.1 | 2.x+ | 2.x+ | 5.6, 5.5, 5.1, 5.0, 4.1 | No |
| 6.0 | 2.x+ | 2.x+ | 5.5, 5.1, 5.0, 4.1 | No |
| 5.2 | 2.x+ | 2.x+ | 5.5, 5.1, 5.0, 4.1 | No |
| 5.1 | 2.x+ | 2.x+ | 5.5, 5.1, 5.0, 4.1, 4.0 | No |
| 5.0 | 2.x+ | 2.x+ | 5.0, 4.1, 4.0 | No |
| 1.0 | 1.x | 1.x | 5.0, 4.1, 4.0 | No |