MySQL 数据库连接与 Visual Studio 2013 预览版

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/18578785/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 18:43:23  来源:igfitidea点击:

MySQL Database Connection With Visual Studio 2013 Preview

mysqlasp.netdatabaseconnectorvisual-studio-2013

提问by Zouhair Elamrani Abou Elassad

I was using Visual Studio 2013 Preview but I couldn't find MySQL database in the "choose data source" dialog window, I even installed the latest version of MySQL connector as well as the windows MySQL installer (to get MySQL plugin for visual studio) but nothing changed, I had to get back to VS 2012 Ultimate, I just wanted to know if there is a special MySQL connector for the 2013 Preview Edition?

我使用的是 Visual Studio 2013 预览版,但在“选择数据源”对话框窗口中找不到 MySQL 数据库,我什至安装了最新版本的 MySQL 连接器以及 Windows MySQL 安装程序(以获得 Visual Studio 的 MySQL 插件)但是没有任何改变,我不得不回到 VS 2012 Ultimate,我只是想知道 2013 预览版是否有特殊的 MySQL 连接器?

回答by Ga???

I am using Visual Studio 2013 Ultimate and I got it working with the Mysql Visual Studio 1.1.1 beta plugin.

我使用的是 Visual Studio 2013 Ultimate,我让它与 Mysql Visual Studio 1.1.1 beta 插件一起工作。

Requirements:

要求:

  • Windows OS 7 or later.
  • Visual Studio 2010, 2012 or 2013 professional or higher version.
  • Connector/Net 6.8.1 beta or higher versionto check the Connector/Net & Entity Framework features. (download at: http://dev.mysql.com/downloads/connector/net/on the development releases).
  • Windows 操作系统 7 或更高版本。
  • Visual Studio 2010、2012 或 2013 专业版或更高版本。
  • 连接器/网络6.8.1 测试版或更高版本以检查连接器/网络和实体框架功能。(在开发版本上下载:http: //dev.mysql.com/downloads/connector/net/)。

Download:

下载:

https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.1.1.msi

https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.1.1.msi

You can find the latest here (v1.2.3):

你可以在这里找到最新的(v1.2.3):

http://dev.mysql.com/downloads/windows/visualstudio/

http://dev.mysql.com/downloads/windows/visualstudio/

Source:

来源:

http://forums.mysql.com/read.php?174,601041,601041#msg-601041

http://forums.mysql.com/read.php?174,601041,601041#msg-601041

回答by Shubham Das

I use Visual Studio 2012. Correct process of installing MySql will help you avoid any such error. At least this is what i did.

我使用 Visual Studio 2012。安装 MySql 的正确过程将帮助您避免任何此类错误。至少这是我所做的。

  1. Download and install visual studio 2012
  2. Download and install mysql-installer-community-5.6.17.0
  3. Download and install mysql-connector-net-6.8.3
  4. Download and install mysql-visualstudio-plugin-1.1.1
  5. Order is important and each item too.
  6. Open Visual Studio and Create new project
  7. Add reference of MySql.Data in solution explorer after right clicking the project name
  8. View server explorer
  9. Add new connection and fill the spaces correctly
  10. At the top of your code, add using MySql.Data.MySqlClient
  1. 下载并安装 Visual Studio 2012
  2. 下载并安装 mysql-installer-community-5.6.17.0
  3. 下载并安装mysql-connector-net-6.8.3
  4. 下载并安装 mysql-visualstudio-plugin-1.1.1
  5. 订单很重要,每个项目也很重要。
  6. 打开 Visual Studio 并创建新项目
  7. 右键单击项目名称后,在解决方案资源管理器中添加 MySql.Data 的引用
  8. 查看服务器资源管理器
  9. 添加新连接并正确填充空格
  10. 在代码的顶部,添加 using MySql.Data.MySqlClient

回答by GayanDeSilva

For Visual studio 2013, install "MySQL for Visual Studio 1.2.8"

对于 Visual Studio 2013,安装“MySQL for Visual Studio 1.2.8”

回答by roguelj

I've not tested it yet, and it's for VS2012 (and I guess it's the same for VS2013) but the following link may help:

我还没有测试过它,它适用于 VS2012(我想它与 VS2013 相同)但以下链接可能会有所帮助:

http://blog.nwoolls.com/2012/07/25/registering-missing-data-providers-with-visual-studio-2012/

http://blog.nwoolls.com/2012/07/25/registering-missing-data-providers-with-visual-studio-2012/