Update db from model in entity framework

Question

I have a data model created, from which I generated a database, if I have to make any changes in my model, how do I update the database generated?. The RE-generate process is useless for me, because database already contain data. I'm using Visual Studio 2010, EF 4.0, SQL 2008.

Thanks in advance.

Similar question : stackoverflow.com/questions/12142/…

Gaurav Agrawal
– Gaurav Agrawal

2012-05-31 13:36:14 +00:00
Commented May 31, 2012 at 13:36 — Gaurav Agrawal
– Gaurav Agrawal, Commented May 31, 2012 at 13:36

Goran Obradovic · Accepted Answer · 2012-05-31 13:33:08Z

0

Basically, you can change your model and DB manually (create/change columns and tables by hand, using SQL Managemets Studio), just delete hash value in EdmMetadata table and EF will not track if your DB is in sync with model anymore. This is quick and dirty solution and you need to take care to keep model in sync with db manually.

Alternatively, you can update to EF 4.3 and take advantage of migrations feature. There are detailed walkthroughs available on: http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-code-based-migrations-walkthrough.aspx and http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-automatic-migrations-walkthrough.aspx

answered May 31, 2012 at 13:33

Goran Obradovic

9,0419 gold badges52 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Update db from model in entity framework

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