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...
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.
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.
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With