How to update a model from a database in Visual Web Developer 2010 Express?

Question

I have an existing model for a MySQL database. I added a new table to my database and now I want to update the model.

But when I right-clicked in the model browser and select Refresh model from database ... I get the following message:

An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException' occurred while attempting to update from the database. The exception message is: ''. 

The application works perfectly with the existing model. I mean, data is successfully retrieved when necessary, and that’s it.

What can cause a problem with updating the model? Is it because of the Express Edition? How can i solve the problem?

UPDATE:

 <connectionStrings> <add name="OtherDbDataContext" connectionString="metadata=res://*/DataAccess.EF.OtherDb.csdl|res://*/DataAccess.EF.OtherDb.ssdl|res://*/DataAccess.EF.OtherDb.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;User Id=id;Password=password;Host=localhost;Database=otherdb;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;Persist Security Info=True&quot;" providerName="System.Data.EntityClient" /> <add name="DbDataContext" connectionString="server=localhost;User Id=id;password=password;Persist Security Info=True;database=db" providerName="MySql.Data.MySqlClient" /> <add name="DbDataConnectionString" connectionString="server=localhost;User Id=id;password=password;Persist Security Info=True;database=db" providerName="MySql.Data.MySqlClient" /> </connectionStrings> 

Answer 1

I think the problem is that the connector / network for mysql does not fully support express versions. Take a look at this post: Mysql - Visual Web Developer - Entity Framework

Answer 2

I fixed this problem by removing all connecting lines from the configuration file. After that, when you update the model, you suggest adding connection strings, and everything works fine.

Hope this helps.

Answer 3

My problem with this was related to the full Event Log . Deleted event log entries, and this solved the problem. Hope this helps someone.

Answer 4

You need to register your supplier in the machine.config file. This happens when the provider is incorrectly registered in the machine.config file.

Answer 5

Try updating the lowest configuration level closest to the .edmx file, which is app.config. In general, the problem is with the connection, and not with the problem in the IDE of the designer.

Answer 6

Same issue with Visual Studio 2012 Professional. After removing the connection string from App.config, I cannot add a new connection in the "Update from database" window. MySQL data source was missing.

Solved by installing MySQL for Visual Studio (for me it was version 1.1.3). I had the opportunity to create connections to the MySQL database. I am returning a connection string and even with an old connection string. Everything was fine.

Hope this helps.