Entity Data Model Wizard crashes on Specify connection string dialog

Question

Whenever I try to add an entity data model in Visual Studio 2013 on Windows 8.1 I see the following.

Does anybody have an idea how to fix this? I see the dialog to specify a database connection appear for a split second then dissapears.

Answer 1

I found a solution. Go into view->Server Explorer and remove any "Data Connections". Then this worked again.

Answer 2

I solved it by doing the following.

• Make sure the versions of MySql.Data, MySql.Data.Entities, MySql.Web dll files in C:\Program Files (x86)\MySQL\MySQL Connector Net x.x.x\Assemblies\v4.5 and C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies are the same.
• Make sure your project references the same version of dll

In my case my

• MySql connector was 6.9.6
• C:\Program Files (x86)\MySQL\MySQL Connector Net x.x.x\Assemblies\v4.5 and C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies had it as 6.8.3
• Project referenced 6.8.3.

After updating all versions with same dlls, now I am able to update the "Model from database"

Hope this helps someone

Edit: A few weeks after there was some windows update which again screwed up the settings. To resolve it, I had to re-run the My Sql Connector installation and My Sql for Visual Studio, it worked fine after that.