mySQL DataSource on Visual Studio 2012

Solution 1:

I have just read from mySQL Forums that mySQL will ship Visual Studio 2012 integration with mySQL Connector v.6.5.5

We'll be adding support for VS 2012 in Connector/NET 6.5.5 and later 6.6.x version http://forums.mysql.com/read.php?38,546265,564533#msg-564533

and give a link to test a trick

http://social.technet.microsoft.com/wiki/pt-br/contents/articles/10476.instalando-mysql-connector-no-visual-studio-2011-beta.aspx

and here is the vsix file if you follow the tutorial (In Portuguese)

Microsoft Visual Studio Extension for mySQL: http://cl.ly/JqXO

just download and double click...

then, you will get all to work

enter image description here

Using Visual Studio 2012 Professional

enter image description here

Solution 2:

One clarification: Visual Studio Express DOES NOT support MySQL .NET Connector as extension.

You still may use it adding reference to MySql.Data.dll file that you may find in MySQL Connector installation folder (for me it was W:\Program Files\MySQL\Connector NET 6.5.4\Assemblies\v4.0). After that you may use it like this:

using MySql.Data.MySqlClient;
...
var mycon = new MySqlConnection();

Solution 3:

According to this page: http://dev.mysql.com/downloads/connector/net/

"Starting with version 6.7, Connector/Net will no longer include the MySQL for Visual Studio integration. That functionality is now available in a separate product called MySQL for Visual Studio available using the MySQL Installer for Windows (see http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html)."