Entity Framework; updating DB from Model?

Question

In mySql Workbench there's a possibility to "sync" the model with the DB and vice versa. Is there a function like this in EF? I've added som entities and I'd like it to get reflected in the DB. Do I really have to regenerate the entire DB and loose data?

Thanks

That is possible with 3rd party tools. My company makes an add-in that gives you two-way incremental comparison and sync between DB, SSDL, and CSDL. See huagati.blogspot.com/2010/07/… for an intro screencast. You can download the add-in from huagati.com/dbmltools and get a trial license from the same site if you want to take it for at test spin. — KristoferA
– KristoferA, Commented Oct 17, 2010 at 15:02

Community · Accepted Answer · 2017-05-23 11:55:22Z

2

Sadly there is no easy way AFAIK to do this today.

One way to handle this is to generate the DDL and then cut and paste the new sections into SQL Server Management Studio and run them there. If you want to maintain scripts for each release of the database you'll need to take an approach like this too.

See also: Database migrations for Entity Framework 4

PS The EF Power Pack: http://msdn.microsoft.com/en-us/data/ff830362.aspx may help. It says "The second useful feature related to model-first the ability to update an existing database and synchronize the model with it. This allows you to make changes to the model that can be deployed to the database without data loss."

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Oct 17, 2010 at 6:20

Ian Mercer

39.4k8 gold badges103 silver badges139 bronze badges

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

4 Comments

Phil Over a year ago

Not the solution I was hoping for but you provided a reasonable work around. Thanks!

Phil Over a year ago

Thank you. It seems as a good way of solving my problem. If I use it I'll comment on how I found it.

Joe Slater Over a year ago

@Phil so how did you find it

Phil Over a year ago

Never used it. Stopped wanting to generate db from models.. too unpredictable

Ruchika rana · Accepted Answer · 2011-03-18 18:24:51Z

-1

if you are using the VS2010 then in Select your edmx designer ( designer showing tables) and right click it will show the update model option.

answered Mar 18, 2011 at 18:24

Ruchika rana

211 bronze badge

1 Comment

Phil Over a year ago

I asked for the other way around. A way to update DB. Thanks anyway.

Collectives™ on Stack Overflow

Entity Framework; updating DB from Model?

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related