Restore a local Sql Server database used by Entity Framework

Question

I'm a beginner with the use of Entity Framework : I have done a web application using EF so i created a local Sql Server database and i added a context class EFDbContext.

When i run the application in another machine i got this error :

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

i think it is because the local database is missing. So i need to know:

In a similaire case, How can i restore my database?
What are the differences between managing databases with Sql Server Manager and the integrated connection tool in VS ?

Do you need to use the same database from the new machine or a new database? — Indi
– Indi, Commented Feb 23, 2014 at 19:47
@Kaf i have done an application , and i need to put it in another machine .So i have to use the same database — Lamloumi Afif
– Lamloumi Afif, Commented Feb 23, 2014 at 19:48
What is your connection string? if you are using localhost, you have to change it to local IP address or network name of the database hosting machine. There may be other issues (according to the error message) but first you need to make sure you can connect to the database. — Indi
– Indi, Commented Feb 23, 2014 at 19:50
Not sure what you mean by a method. But if you need to create the database in the new machine, you can use Package Manager Console and run update-database command to do it. — Indi
– Indi, Commented Feb 23, 2014 at 20:03
(1). PM> enable-migrations (2). PM> add-migration db_migrationX (3). PM> update-database. Note: you may not need (1) and (2) if you have created migrations before. — Indi
– Indi, Commented Feb 23, 2014 at 20:12

Indi · Accepted Answer · 2014-02-23 20:47:50Z

2

As per comments, you can create the database in the new machine using Package Manager Console. Please follow the following steps.

(1). PM> enable-migrations 
(2). PM> add-migration db_migrationX 
(3). PM> update-database.

Note: you may not need (1) and (2) if you have created migrations before.

answered Feb 23, 2014 at 20:47

Indi

33.9k7 gold badges61 silver badges80 bronze badges

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

Collectives™ on Stack Overflow

Restore a local Sql Server database used by Entity Framework

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