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

c# entity-framework visual-studio-2013

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

1
11
10/26/2015 1:28:39 PM

Accepted Answer

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?

6
11/21/2013 10:51:33 AM

Popular Answer

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.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow