Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I connect to MySQL 5.1 in Visual Studio 2010?

Tags:

Does any one know how to connect to MySQL 5.1 with Visual Studio 2010?

I have already tried the MySQL Connector/ODBC route and it got me really nasty results. The table rows were all listed as a view in the views section and nothing at all was listed in the tables or procedures folder.

like image 354
jake Avatar asked May 23 '09 07:05

jake


People also ask

What version of Visual Studio do I need for MySQL?

If you are installing MySQL on Windows, It requires Visual studio to be installed on your system. At the time of answering this question, supported versions are visual studio 2012, 2013, 2015 or 2017.

Does Visual Studio work with MySQL?

MySQL for Visual Studio provides access to MySQL objects and data from Visual Studio. As a Visual Studio package, MySQL for Visual Studio integrates directly into Server Explorer providing the ability to create new connections and work with MySQL database objects.


2 Answers

To get the Entity Frame working with VS2010, I had to do the following:

  1. This only worked with Mysql .net Connector v6.3.1 (alpha). Previous versions ignored VS 2010 (click Development Releases)
  2. I had to rename my Framework\v1.1.4322\CONFIG folder. Otherwise the install will fail. Rename it back when finished

(I've blogged about this here)

Update 6.3.2 is in beta and I can confirm this works. (I didn't need to rename the framework folder)

like image 82
Christian Payne Avatar answered Sep 28 '22 16:09

Christian Payne


this seems to solve the issue

UPDATED LINK TO LATEST RELEASE THANKS @Christian Payne

Update: looks like there is already a non-beta!!!!

http://www.mysql.com/downloads/connector/net/

like image 25
Luiscencio Avatar answered Sep 28 '22 17:09

Luiscencio