Dynamic library configuration of MySQL database and Net version

Experience: when using the C # and MySQL databases to connect, you must pay attention to the problem of matching the two. Otherwise, the database may not be connected. First, you need to know clearly, and then download the Correct Connection Library from the official website;

The content from the MySQL Official Website: http://dev.mysql.com/doc/refman/4.1/en/connector-net-versions.html

The following content is from the MySQL official website.

17.2.1. connector/NET versions

There are several versions of connector/net available:

• Connector/NET 1.0 connector des support for MySQL Server 4.0, 4.1, and 5.0 features, and full compatibility with the ADO. Net driver interface.

  This version of connector/net is no longer supported.

• Connector/NET 5.0 connector des support for MySQL Server 4.0, 4.1, 5.0 and 5.1 features. connector/NET 5.0 also 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 5.1 connector des support for MySQL Server 4.0, 4.1, 5.0, 5.1, 5.4 and 5.5 features. connector/NET 5.1 also includes support for a new membership/role provider, Compact Framework 2.0, a new stored procedure parser and improvementsGetSchema. Connector/NET 5.1 also plugin des the Visual Studio plugin as a standard installable component.

  This version of connector/net is no longer supported.

• Connector/NET 5.2 connector des support for MySQL Server 4.1, 5.0, 5.1, 5.4, and 5.5 features. connector/NET 5.2 also includes support for a new membership/role provider, Compact Framework 2.0, a new stored procedure parser and improvementsGetSchema. Connector/NET 5.2 also plugin des the Visual Studio plugin as a standard installable component.

  This version of connector/net is no longer supported.

• Connector/NET 6.0 connector des support for MySQL Server 4.1, 5.0, 5.1, 5.4 and 5.5.

  This version of connector/net is no longer supported.

• Connector/NET 6.1 connector des support for MySQL Server 4.1, 5.0, 5.1, 5.4, and 5.5. Important new features include the MySQL website Configuration tool and a session State provider.

• Connector/NET 6.2 connector des support for MySQL Server 4.1, 5.0, 5.1, 5.4, and 5.5. important new features include a new logging system and client SSL certificates. connector/NET 6.2 is currently available as a beta release.

• Connector/NET 6.3 connector des support for MySQL Server 5.0, 5.1, 5.4, and 5.5. important new features include integration with Visual Studio 2010, such as 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. connector/NET 6.3 is available as a beta release.

The latest source code for connector/NET can be downloaded from the MySQL public Subversion server. For further details see section 17.2.2.3, "installing connector/net from the source code ".

The following table shows the. NET Framework version required, and MySQL Server version supported by connector/NET:

Connector/Net version	Ado. Net version supported	. NET Framework Version Required	MySQL Server version supported	Currently supported
1.0	1. x	1. x	4.0, 4.1, 5.0	No
5.0	2. x +	2. x +	4.0, 4.1, 5.0	No
5.1	2. x +	2. x +	4.0, 4.1, 5.0, 5.1, 5.4, 5.5	No
5.2	2. x +	2. x +	4.1, 5.0, 5.1, 5.4, 5.5	No
6.0	2. x +	2. x +	4.1, 5.0, 5.1, 5.4, 5.5	Critical issues only
6.1	2. x +	2. x +	4.1, 5.0, 5.1, 5.4, 5.5	Yes
6.2	2. x +	2. x +	4.1, 5.0, 5.1, 5.4, 5.5	Yes
6.3	2. x +	2. x +, 4.x+ for vs 2010 support	5.0, 5.1, 5.4, 5.5	Yes

Note

Version numbers for MySQL products are formatted as x.y. z, where z = 0 indicates Alpha, Z = 1 indicates beta, and z> = 2 indicates ga. however, Windows tools (control panel, properties display) may show the version numbers as XX. YY. ZZ. for example, the official MySQL formatted version number 5.0.9 may be displayed by Windows tools as 5.00.09. the two versions are the same; only the number display format is different.