EF Database first how to update model for database changes?

Question

In a class library Ado.net Entity Data Model is has generated POCO classes. These were generated fine for the first time. But database changes are not being reflected. In edmx diagram right clicking and choosing Update Model from Database show newly created table but it do not add table even after selecting it to add.

I tried running .tt (by right click and Run custom tool) but even it did not regenerated the Poco classes as per latest DB changes.

Help please

On the second tab, did you select the table you wanted to refresh ? — Yuliam Chandra
– Yuliam Chandra, Commented Sep 9, 2014 at 5:33
Make sure to save the edmx file after doing Update Model from Database — Chris Gong
– Chris Gong, Commented Jul 25, 2017 at 17:23

Joel Peltonen · Accepted Answer · 2015-07-06 12:23:13Z

7

Not a fix but a workaround: Is it not an option to simply remove and regenerate the EDMX and the generated classes? That's what I do, it is much easier than working with the update feature, and the result seems to be the same. Your POCO extensions still remain the same and functional.

I use database first and I have my SQL upgrade scripts, the generated EDMX and my Generated models in source control and the changes there are very easy to manage. Here is a rough outline of my DB upgrade process for each version:

Create .sql script for the upgrade, statements like CREATE TABLE etc.
Delete generated files: Model.Context.tt, Model.tt, Model.edmx
Remove Entities string from Web.config (if you use it)
Create the EDMX and Context files the same way you did for the first time
If you use source control (I hope you do!) check what has changed
Test
Commit!

edited Jul 6, 2015 at 12:23

answered Sep 9, 2014 at 5:45

Joel Peltonen

13.5k7 gold badges68 silver badges108 bronze badges

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

Comments

akcza · Accepted Answer · 2016-08-30 14:01:30Z

0

In my case i needed to save ModelName.edmx, then classes were generated.

answered Aug 30, 2016 at 14:01

akcza

431 gold badge1 silver badge6 bronze badges

Comments

Sudip Arora · Accepted Answer · 2017-05-11 11:37:26Z

0

Ensure that connections string in app.config is correct. I was using a DataDictionary and my connection string had the following path:

data source=|DataDirectory|*.sqlite

Thus, it wasn't updating. Because this DataDirectory variable was being resolved at runtime.

answered May 11, 2017 at 11:37

Sudip Arora

114 bronze badges

Collectives™ on Stack Overflow

EF Database first how to update model for database changes?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related