Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unable to update EntityFramework models from MySQL database in Visual Studio 2015 RC

My organization upgraded from Visual Studio 2013 to Visual Studio 2015 RC a couple months ago, and we only just now attempted to update some of our existing "db-first" EntityFramework models from our MySQL database. When doing so, we received the following error.

An exception of type 'System.ArgumentException' occurred while attempting to update from the database. The exception message is: 'Unable to convert runtime connection string to its design-time equivalent. The libraries required to enable Visual Studio to communicate with the database for design purposes (DDEX provider) are not installed for provider 'MySql.Data.MySqlClient'.

A quick SO search for this error produced this result from November of 2013 (specifically in reference to VS 2013)...

Apparently MySql and Visual Studio 2013 don't work together yet.

Here is a link on the MySql forums: http://forums.mysql.com/read.php?174,594798,600466#msg-600466

You'll probably need to wait for the next release of the MySql connector.

Does that mean this is likely a comparable issue, and we just have to wait it out until a new MySql.Data client is available that is compatible with VS 2015? Or is it possible that some other cause is to blame (perhaps a bug in VS 2015 RC)?

We're on the latest stable versions of Entity Framework (6.1.3), MySql.Data (6.9.6) and MySql.Data.Entity (6.9.6).

Especially curious to hear if anyone else has stumbled across this issue with VS 2015 RC in particular.

like image 344
Mike Avatar asked Jul 02 '15 07:07

Mike


2 Answers

In my case, I installed Visual Studio right after Mysql installing. Therefore Mysql Visual Studio components weren't installed.

To fix that just open MySQL for VS install and pick "Change"

Then check components for target Visual Stadio version

enter image description here enter image description here

like image 64
kkost Avatar answered Oct 21 '22 08:10

kkost


What worked for me was to update the visual studio plugin, available here: http://dev.mysql.com/downloads/windows/visualstudio/

like image 43
Michael Malone Avatar answered Oct 21 '22 08:10

Michael Malone