Visual Studio 2012的mySQL数据源。

I've been reading about mySQL DataSource and the ability to use mySQL with Entity Framework, but I can't really generate EF with mySQL without the use of the DataSource Dialog

我一直在阅读mySQL的数据源和使用mySQL的实体框架的能力，但是我不能在没有使用DataSource对话框的情况下使用mySQL来生成EF。

How can I add mySQL Database to such dialog?

如何将mySQL数据库添加到该对话框中?

This is what I have done so far:

这是我迄今为止所做的:

• Installed mySQL Connector v.6.5.4
• 安装mySQL连接器v.6.5.4
• Restarted n-times my Windows 7 machine
• 重启n次我的Windows 7机器。
• Read all about how well mySQL Connector works on previous versions of Visual Studio
• 阅读所有关于mySQL连接器在以前版本的Visual Studio上的工作。

7 个解决方案

#1

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

我刚从mySQL论坛上读到mySQL将会将Visual Studio 2012集成到mySQL Connector .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

我们将在连接器/NET 6.5.5和之后的6.6中增加对VS 2012的支持。x版本http://forums.mysql.com/read.php?38,546265、564533 #味精- 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

http://social.technet.microsoft.com/wiki/pt - br/contents/articles/10476.instalando mysql - connector -不-视觉工作室- 2011 beta.aspx

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

这是vsix文件，如果你跟随教程(葡萄牙语)

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

Microsoft Visual Studio扩展mySQL: http://cl.ly/JqXO。

just download and double click...

只需下载并双击…

then, you will get all to work

然后，你就可以开始工作了。

Using Visual Studio 2012 Professional

使用Visual Studio 2012 Professional。

#2

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

一个说明:Visual Studio Express不支持MySQL . net连接器作为扩展。

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:

您仍然可以使用它添加对MySql.Data的引用。您可以在MySQL连接器安装文件夹中找到dll文件(对我来说是W:\程序文件\MySQL\连接器网络6.5.4\程序集\v4.0)。之后你可以这样使用:

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

#3

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

根据这个页面: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)."

从版本6.7开始，连接器/网络将不再包括Visual Studio集成的MySQL。这个功能现在可以在一个名为MySQL的独立产品中使用，Visual Studio可以使用MySQL安装程序进行Windows操作(参见http://dev.mysql.com/techresources/articles/mysql - Installer -for- Windows .html)。

#4

Visual Studio 2012 is not yet supported by MySQL Connector v.6.5.4. You can't add a connection to MySQL in the Server Explorer to begin with.

Visual Studio 2012还没有得到MySQL连接器v6.5.4的支持。您不能在服务器资源管理器中添加到MySQL的连接。

According on this post, support will be added on MySQL Connector v.6.5.5

根据这篇文章，MySQL连接器v6.5.5将添加支持。

#5

Connector/NET 6.5.5 does not support VS2012, but Connector/NEt 6.6.x does.

连接器/NET 6.5.5不支持VS2012，但连接器/NET 6.6。x。

However Visual Studio Express editions are not supported, hence the only way to work in Entity Framework and Visual Studio Express and MySql (or other database different than SQL Server for that matter) is using code first.

然而，Visual Studio Express的版本不受支持，因此在实体框架和Visual Studio Express和MySql(或其他与SQL Server不同的数据库)中工作的唯一方法是先使用代码。

#6

It wouldn't matter if you had the MySQL driver showing as far as I can tell. I'm running VS 2012.3 and if I try to create a Data Connection in VS Server Browser, I can get as far as selecting the MySQL driver and no more. If I try typing a servername/username/password (any of the fields), the window just disappears and YES, it's only when the MySQL driver is being used so NO it's not vs (not exclusively) causing the problem. Go ahead and say that it's my environment but you'd not be able to justify that even remotely compared to the FACT of what is happening. ALL my other software/extentions/add-in/libraries work just fine. No surprise either seeing how buggy the "3 minute" Windows Installer was. Had to uninstall/reinstall a server instance to get to the configuration wizard and there is no other apparent way to configure an instance without it. I'd rather have the old setup. /rant

如果你能让MySQL驱动程序显示出来，那就不重要了。我正在运行VS . 2012.3，如果我尝试在VS服务器浏览器中创建一个数据连接，我可以选择MySQL驱动程序，而不是更多。如果我尝试键入一个servername/用户名/密码(任何字段)，窗口就会消失，是的，只有在使用MySQL驱动程序时，才不会导致问题。继续说，这是我的环境，但你无法证明即使远比实际发生的情况。我所有其他的软件/扩展/外接程序/库都很好。看到“三分钟”的Windows安装程序有多糟糕，也就不足为奇了。必须卸载/重新安装服务器实例以获得配置向导，没有其他明显的方法来配置实例。我宁愿要旧的装置。/咆哮

#7

Downloaded and install Download MySQL for Visual Studio http://dev.mysql.com/downloads/windows/visualstudio/1.1.html

下载并安装Visual Studio http://dev.mysql.com/downloads/windows/visualstudio/1.1.html。