Unable to convert runtime connection string to its design-time equivalent

Question

I updated to Visual Studio 2013 last week and I can no longer update my Entity Data model through the visual studio designer (.edmx file).

When I right click > update model from database I now receive this 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. Connection string: server=192.168.100.103;user id=xxx;password=xxx;database=xxx;persist security info=True'.

My connection string is as follows:

  <connectionStrings>
<add name="DbEntities" connectionString="metadata=res://*/Db.csdl|res://*/Db.ssdl|res://*/Db.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=192.168.100.103;user id=xxx;password=xxx;database=xxx;persist security info=True&quot;" providerName="System.Data.EntityClient" />

The process still works fine in Visual Studio 2012

Answer 1

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.

I can't even create a connection to a MySql DB from Server Exploer in Visual Studio 2013. Can you?

Answer 2

You need to download Mysql connector 6.8.3.0 and Mysql for Visual Studio 1.1.1(https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.1.1.msi)

After that, it worked for me.

Answer 3

There is a new product for this now: http://dev.mysql.com/downloads/windows/visualstudio/

Worked for me!

Answer 4

I had a similar problem with SQL Server Compact Edition. Although implied above, I'll explicitly state it: The answer for me was starting it in VS2012 and following the same steps to generate the database from the .edmx as I had tried in VS2013.

Answer 5

Most likely you are using an older version of MYSQL for VS or do not have any installed. Simply Install/Update MySQL for visual studio here : http://dev.mysql.com/downloads/windows/visualstudio/

This Worked for me