ADO.NET Entity Data Model doesn't update Entities

Question

I'm using MySQL .NET Connector in my ASP.NET MVC project. The connection works fine.

However, after creating a ADO.NET Data Model from my MySQL database (with "Update Model from Database") for the first time, each time I change the database in any way (add/remove tables/properties) and choose "Update Model from Database" again, the .edmx file (designer) updates, but the Entities don't.

How can I update everything? I tried to delete the table from the designer and going through "Update Model from Database" again, it adds the tables to the designer, but the Entities never change.

Is there any way to do this properly?

Walkthrough through the problem:

Add table users to designer

Add column phone to database table users and refresh Server Explorer, making sure the column is there.

Refresh the Data Model, by going to "Update Model from Database" and choosing users table in Refresh tab.

The column phone is added to the designer. Everything seems be working fine.

Going to the code, the property phone is not in the Entity class.

Is your edmx file by any chance nested in a folder and you don't have VS 2011 Update 1? It seems to me this is a bug that was fixed in VS 2011 Update 1 where the code would not be generated if the edmx file is in a nested folder. The work around is to right click the tt file and select "Run Custom Tool". Relevant links: stackoverflow.com/questions/12734333/… and entityframework.codeplex.com/workitem/453 — Pawel
– Pawel, Commented May 29, 2013 at 18:16
Yes that solved the problem. Could you answer the question and I'll mark your answer as the accepted answer? — Gaui
– Gaui, Commented May 29, 2013 at 18:37

Gaui · Accepted Answer · 2013-05-29 19:03:36Z

4

@Pawel answered this question, but I want to add an accepted answer.

This is a known bug in Visual Studio 2012:

http://entityframework.codeplex.com/workitem/453

This can be fixed with Visual Studio 2012 Update:

http://www.microsoft.com/en-us/download/details.aspx?id=38188

answered May 29, 2013 at 19:03

Gaui

9,00917 gold badges68 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ADO.NET Entity Data Model doesn't update Entities

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related