Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Provider for VS11 Developer Preview

Is there any MySQL connection provider that integrates with Visual Studio 11 Developer Preview?

I've tried the MySQL connector v6.4.4 but I don't see the option to connect to a MySQL database from the new connection dialog...

like image 571
em70 Avatar asked Dec 23 '11 13:12

em70


People also ask

Does Visual Studio 2022 support MySQL?

MySQL isn't supported for Visual Studio 2022 yet. it's weird and frustrating, to be honest, but if you want to work with MySQL with VS22, you either need to change the Database or go back to VS19.

What is MySQL for Visual Studio?

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.


3 Answers

I tweaked the .Net Connector version 6.5.4 to make it work with Visual Studio 11 developer preview as well as Visual studio 2012.

It a simple matter of adding a few lines to the manifest file.

It can be downloaded here

Just double click it and check the Visual Studio 2012 RC check box.

Update MySQL has released the beta of their connector 6.6.2, with Visual Studio 2012 support. Get it here.

like image 185
Jesper Fyhr Knudsen Avatar answered Oct 16 '22 19:10

Jesper Fyhr Knudsen


I used Arkain's solution and it worked nicely, untill i wanted to generate the MySQL script to generate my database. In the DDL Generation Template i did not have the SSDLToMySQL.tt(VS) choice.

This can be solved by copying the 2 files located in C:\VSPath\Extensions\Microsoft\Entity Framework Tools\DBGen to C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\DBGen some of you might have placed vs somewhere else.

like image 20
Martin Sax Avatar answered Oct 16 '22 17:10

Martin Sax


For as far as I know each mysql connector msi file needs builtin support for a specific version of visual studio. I did a quick search within my Visual Studio 2010 folders and found that there is a Mysql .Net Connector folder in the Extensions folder:

C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Extensions\Oracle\MySQL Connector Net\

I haven't tried it, but you could give it a go copy/paste this folder to your Visual Studio 11 folder. But i'am expecting that there is more to be done than just simple copy/paste it.

like image 20
ChristiaanV Avatar answered Oct 16 '22 18:10

ChristiaanV