mysql 数据库和net 的版本动态库搭配问题

  心得体会：在使用c#和mysql数据库连接的时候一定要注意二者的搭配问题，否则可能造成数据库连接不上。先认识清楚，然后再从官网下载正确的连接库即可；

一下内容来自mysql官方网站：http://dev.mysql.com/doc/refman/4.1/en/connector-net-versions.html

一下内容来自mysql官网

17.2.1. Connector/NET Versions

There are several versions of Connector/NET available:

• Connector/NET 1.0 includes 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 includes 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 includes 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 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.2 includes 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 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 6.0 includes 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 includes 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 includes 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 includes 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.