How can i add a table in my existing database without losing data in Entity-framework Code first 5.0 ?

Question

Recently I updated my software and I need to add a new table in my database. I am using

Update-Database -Force -Verbose

to update my database in my development PC. But when I install update version of my software in my client machine then it throw following exception.

The model backing the ‘MyContext’ context has changed since the database was created. Consider using Code First Migrations to update the database (http://go.microsoft.com/fwlink/?LinkId=238269)

If I drop and recreate database then it`s work fine.

But it is quite impossible to drop existing database in my client machine. I have to add my new table without losing any data.

Please tell me how can i add a new table without out losing data in my existing Database.

I am using

Visual Studio 2012
Entity Framework 5.0
DotNet 4.0
MSSQL Server 2008 R2

Did you follow the link to learn about Code First Migrations? That's how to update your database without dropping it using EF. — Jimmy
– Jimmy, Commented Mar 4, 2013 at 16:31

Robert · Accepted Answer · 2013-03-04 16:41:14Z

4

You need to use Code First Migrations. When you set up your DbContext it will look something like this:

Database.SetInitializer<dbContext>(new MigrateDatabaseToLatestVersion<dbContext, Configuration>());

answered Mar 4, 2013 at 16:41

Robert

4,41611 gold badges57 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

How can i add a table in my existing database without losing data in Entity-framework Code first 5.0 ?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related