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="server=192.168.100.103;user id=xxx;password=xxx;database=xxx;persist security info=True"" providerName="System.Data.EntityClient" />
The process still works fine in Visual Studio 2012
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?
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.