How to update Database Modification at the Entity from Entity Model?

Question

I've designed the entity model which has been mapped from the Sql server database. Later on, I've updated the Identity column in a particular table in database then I've done Update Model fromDatabase. Unfortunatly, It wasn't updated in my Entity Model. What should I do to sort it out ?

Any help or suggestion are greatly appreciated !!!

Drop and re-add the table to your model? I know EF is fussy with changes to identities and existing columns — Koenyn
– Koenyn, Commented Mar 27, 2013 at 9:16
It's annoying me to re-add the table. Is there any other possibilities ? — Smaug
– Smaug, Commented Mar 27, 2013 at 9:23

Rob Epstein · Accepted Answer · 2013-03-27 09:48:11Z

1

Manually edit the EDMX either in Designer or Xml view, whichever is your preference.

answered Mar 27, 2013 at 9:48

Rob Epstein

1,5209 silver badges11 bronze badges

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

3 Comments

Smaug Over a year ago

During the 1st time It has generated automatically. My point is the update also should be happen automatically. Am i right ?

Rob Epstein Over a year ago

As Koenyn correctly pointed out there are scenarios in which the Update function won't be able to update your model. One such scenario is key column changes. If you were to just add a table, relationship or column you would be in good shape. If you'd rather not edit the EDMX then you can always kill it and regen it completely as you did the first time.

Smaug Over a year ago

Seems very bad designer Issue. Rob Epstein thanks for your suggestion. I planned to edit manually.

Collectives™ on Stack Overflow

How to update Database Modification at the Entity from Entity Model?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related