Mysql – How to connect to MySQL 5.1 in Visual Studio 2010

mysqlvisual-studio-2010

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.

Best Solution

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)