适用于Visual Studio 2012/2013的MySQL [英] MySQL For Visual Studio 2012/2013

问题描述

我想使用MySQL数据库创建EF模型.我在64位计算机上运行VS2012和VS2013.当需要添加新连接时，我需要安装什么才能使MySQL出现在实体数据模型向导"中?我尝试添加MySQL.Data.Entities Nuget程序包，但仍然没有在向导中获得该选项.在搜索MySQL .NET Connector时，我只能找到32位下载.请告知.

I would like to create a EF model using a MySQL database. I am running VS2012 and VS2013 on a 64 bit machine. What do I need to install to get MySQL to show up in the Entity Data Model Wizard when it's time to add a new connection ? I tried adding MySQL.Data.Entities Nuget package, but I still do not get the option in the wizard. When searching for MySQL .NET Connector, I only find 32 bit downloads. Please advise.

谢谢

更新:

我再次运行MySQL安装程序，发现未安装用于Visual Studio的MySQL.我再次运行它并得到一个错误.这是安装详细信息的结尾:

I ran the MySQL installer again and noticed the MySQL for Visual Studio was not installed. I ran it again and get an error. Here is the end of the install details:

1:文件:license-zlib-net.html，目录:C:\ Program Files(x86)\ MySQL \ MySQL for Visual Studio 1.0.2 \ Documentation \ Licenses for Third-Party Components \，大小:17171 1:操作6:09:56:ManagedDataInstall.在machine.config中注册数据提供者 1:动作6:09:56:回滚.回滚动作: 1:在machine.config中注册数据提供程序 1:复制新文件 1:创建文件夹 1:更新组件注册 1:1:适用于Visual Studio 1.0.2的MySQL 2:{0D406BCC-D62A-46FB-9AB7-A7BF10FB8B31} 3:3 1: 1:最终动作. 1:安装错误

1: File: license-zlib-net.html, Directory: C:\Program Files (x86)\MySQL\MySQL for Visual Studio 1.0.2\Documentation\Licenses for Third-Party Components\, Size: 17171 1: Action 6:09:56: ManagedDataInstall. Registering data provider in machine.config 1: Action 6:09:56: Rollback. Rolling back action: 1: Registering data provider in machine.config 1: Copying new files 1: Creating folders 1: Updating component registration 1: 1: MySQL for Visual Studio 1.0.2 2: {0D406BCC-D62A-46FB-9AB7-A7BF10FB8B31} 3: 3 1: 1: Final actions. 1: Install error

我可以粘贴详细信息的全部内容，但希望有足够的信息.这提供任何线索吗?看起来安装似乎在修改machine.config文件时遇到麻烦，但是我通过添加每个人"以拥有读写权限(暂时)来更改了这些文件的安全性.

I can paste the entire contents of the details, but was hoping there is enough information. Does this offer any clues ? It almost looked like the install was having trouble modifying the machine.config files, but I changed the security on these files by adding "Everyone" to have read and write permission (temporarily).

推荐答案

对于Visual Studio 2013环境，请从下面的链接下载并安装适用于Visual Studio 1.1.1的MySQL，然后您将能够在数据源中看到MySQL数据提供程序.列表.

For Visual Studio 2013 environment, download and install MySQL for Visual Studio 1.1.1 from the link below then you will be able to see MySQL Data Provider in Data Source list.

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

这篇关于适用于Visual Studio 2012/2013的MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！