Update database schema at runtime with Entity Framework

Question

I'm developing an application with EF4.0. Between the releases the database schema can change (e.g. column added, table added...).

Is there a way to commit these changes to the customers database when they run the new release? I'm thinking of an function similar to CreateDatabase().

I'm almost sure that there is nothing like this out of the box. Creating a function to migrate DB schema with no data lost will be very hard task if ever possible. For example, context always has the latest version of storage schema, think about that. — Yury Tarabanko
– Yury Tarabanko, Commented Jun 30, 2010 at 12:46
Possible duplicate of Entity Framework 4 - Update database schema from model. Without wiping the table data. I believe this question answers yours. — Craig Stuntz
– Craig Stuntz, Commented Jun 30, 2010 at 13:16
No, the question you linked seems to handle the database update from the EF designer. But i'm looking for a way to alter the database when the customer runs an update without running a "handmade" sql script. — BLahr
– BLahr, Commented Jun 30, 2010 at 13:40
You don't need a "handmade" script. VS will make the script for you. You just need to run it. — Craig Stuntz
– Craig Stuntz, Commented Jun 30, 2010 at 13:42
Yes, he does. And the VS 2010 schema migration (formerly "data dude") knows how to do this. — Craig Stuntz
– Craig Stuntz, Commented Jun 30, 2010 at 20:57

Shiraz Bhaiji · Accepted Answer · 2010-09-03 18:43:55Z

1

Your install procedure must do two things:

Run a script to update the database
Install the new program files

To generate the database script use the tools in visual studio, see http://www.sqlskills.com/BLOGS/KIMBERLY/post/Data-Dude-moving-into-lower-priced-VS-Editions-in-VS-2010-excellent!.aspx

answered Sep 3, 2010 at 18:43

Shiraz Bhaiji

65.7k37 gold badges149 silver badges260 bronze badges

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

Collectives™ on Stack Overflow

Update database schema at runtime with 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