7

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?

Flexo
  • 87,323
  • 22
  • 191
  • 272
Zouhair Elamrani Abou Elassad
  • 210
  • 1
  • 3
  • 9

4 Answers4

18

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

Requirements:

  • Windows OS 7 or later.
  • Visual Studio 2010, 2012 or 2013 professional or higher version.
  • Connector/Net 6.8.1 beta or higher version to check the Connector/Net & Entity Framework features. (download at: http://dev.mysql.com/downloads/connector/net/ on the development releases).

Download:

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

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

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

Source:

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

Gaʀʀʏ
  • 4,372
  • 3
  • 39
  • 59
  • Thank you for posting this. – Max Young Dec 24 '13 at 14:47
  • Do I need to restart the PC after install this.Because it's not work for me. – Ren Mar 18 '14 at 07:14
  • @Ren [Mysql Visual Studio 1.1.4](http://forums.mysql.com/read.php?3,609530) has been released. Try with that version. – Gaʀʀʏ Mar 18 '14 at 13:27
  • Always look for newest version... :-) [search here](http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-for-VisualStudio/). currently, latest version name is `mysql-for-visualstudio-1.2.3.msi` – itsho Nov 06 '14 at 21:20
4

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

  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
Shubham Das
  • 1,257
  • 11
  • 10
2

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

GayanDeSilva
  • 81
  • 1
  • 6
1

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:

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

roguelj
  • 11
  • 1
  • 1