The model backing the '--Context' context has changed since the database was created - but db is new production database

azure c# entity-framework

Question

I've got this error for the 762nd time but this time I am getting it as soon as I attempt to access my Production site, straight after deleting the 'production' database on Azure and then publishing my site.

The model backing the 'PropertyContext' context has changed since the database was created. Consider using Code First Migrations to update the database

I deleted the database because I couldn't fix this issue any other way but it still doesn't work.

Some important points:

  • I'm using EF6 and publishing to Azure.
  • This is 1 of 2 projects/sites that uses the same Repo project. I have no
    problems with the other one, just this one.
  • I have tried publishing the problem project first (after deleting the db) and second with the same result.
  • I have tried deleting both WEBSITES and the DB from Azure and starting again
  • I have tried deleting all migrations and starting with a fresh data model

  • I have tried the following in my Global.asax (in both projects)

    Database.SetInitializer PropertyContext>(null); <-- SO won't let me put the first <

and

Database.SetInitializer(new MigrateDatabaseToLatestVersion<PropertyContext, MyConfiguration>());
new PropertyContext().Database.Initialize(true);

I'm using .net 4.5

Why am I getting this error on a new database and how can I get this site to work?

1
24
2/19/2014 8:16:56 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Just ran into the same error in ASP.Net application. In my case I did not use Code First, but I used standard ASP.Net authentication provider which apparently uses Code First, and authentication was broken because of this issue.

Here is quick and dirty solution is you don't care much about existing user records:

For me the solution was to drop the dbo.__MigrationHistory table, authentication started working fine after that. Be aware! This solution is not for everyone! This will fix the problem, but it is potentially risky.

If you cannot afford to lose data in AspNet* tables:

ASP.Net authentication provider automatically creates tables in your database:

  • AspNetRoles
  • AspNetUsers
  • AspNetUserRoles
  • AspNetUserClaims
  • AspNetUserLogings

The tables are empty by default, if you haven't created any new logins for your web site, you can use "quick and dirty" solution above. If you do care about preserving user information or just curios how Code First migrations work, follow these steps:

  • Open your Web.config file and check the name of the connection string you have for your database. It will be one of the records under <connectionStrings> element.

  • Open Package Manager Console:

    Tools –> Library Package Manager –> Package Manager Console

  • In Package Manager Console window, use a drop-down to set Default Project. Make sure this is the project that contains ASP.Net authentication provider code.
  • Execute command:
    Update-Database -ConnectionStringName MyConnectionStringName

Replace the MyConnectionStringName with the actual name you looked up in web.config.

As a result of this command you will see a new folder "Migrations" with a bunch of code generated by the Update-Database command. Re-build and re-deploy your app, your new migration code will be executed on startup and would bring the database schema in sync with an updated version of ASP.Net authentication provider code.

36
1/15/2016 4:56:46 PM

Popular Answer

When using Code First with Migrations, your database creates a table called __MigrationHistory to track the current schema. When you run your application your Entity Framework will check this table to make sure that the database schema matches your database entities. If they do not match, you will get this error.

To update your database follow these steps:

  1. Open the Package Manager Console (View -> Other Windows -> Package Manager Console) in Visual Studio
  2. In the Package Manager Console Window, there is a drop down with your projects in, make sure it is set to the project that contains your DbContext
  3. Make sure that the project that contains your App.Config / Web.Config file is "Set as Startup Project" (If you have multiple Configs, it must be the one with the Database Connection String defined.
  4. Type Update-Database -ConnectionStringName MyConnString where MyConnString is the name (not the actual connection string) of your connection string in your App.Config / Web.Config

If you get an error like this: "Unable to update database to match the current model because there are pending changes and automatic migration is disabled."

You should enable Automatic Migrations and try again. To enable Automatic Migrations

  1. In the Migrations folder (in the project with your DbContext), open Configuration.cs.
  2. Make sure the Constructor contains: AutomaticMigrationsEnabled = true;

To stop Entity Framework/DbContext from monitoring changes on your database you could simply delete the __MigrationHistory table in your database. It is then up to you to make sure that the database remains updated manually.

MSDN article here

Talon

Related Questions

Instead of "Generate Database from Model," Entitiy Framework uses "Update Database from Model."

Noam Ben-Ami - MSFT1 (Microsoft Employee) answered my question at ...http://social.msdn.microsoft.com/Forums/en-us/adodotnetentityframework/thread/3adc080f-ee8c-4104-be29-95b2fb3fabe9... as follows:...We've build the entity designer database power pack to support this. You can download it here: ...http://visualstudiogallery.msdn.microsoft.com/en-us...
entity-framework visual-studio-2010
asked by David

Model backing a DB Context has changed; Consider Code First Migrations

EF codefirst will look at your DbContext, and discover all the entity collections declared in it(and also look at entities related to those entities via navigation properties). It will then look at the database you gave it a connection string to, and make sure all of the tables there match the structure of your entities in model. If they do not ma...
asp.net-mvc entity-framework
asked by AaronLS

EF6 Beta1 - db.Database.CreateIfNotExists(); doesn't create the database anymore after enabling the migration

EF team responded me that it's a new changes in EF. Please refer to this thread. ...https://entityframework.codeplex.com/discussions/450998
entity-framework entity-framework-6
asked by Michael Sync

DropCreateDatabaseIfModelChanges EF6 results in System.InvalidOperationException: The model backing the context has changed

Well, it looks like EF 6.0 introduces a new rule:..."If the DbContext is using an Initializer AND Migrations are configured, throw an exception when building the model"....Up to and including the EF 6 RC this wasn't enforced. The annoying part is that "Migrations are configured" is defined by the implementation of a DbMigrationsConfiguration. There...
.net c# entity-framework entity-framework-6
asked by Stefan Mohr

The model backing the 'EFDbContext' context has changed since the database was created

Add ...Database.SetInitializer<EFDbContext>(null); ...To your Global.asax file to disable ef migrations. It seems you have migrations enabled for some reason.
asp.net-mvc-5 c# entity-framework linq sql
asked by Jimmyt1988

The model backing the 'ApplicationDbContext' context has changed since the database was created

It was such a strange error,, It wasn't my error at the end, it was Microsoft's,, I installed the Entity framework the " pre-release" version and it was responsible for this error,, when i upgraded to the stable release it disapperared,, thank you everyone believe me when i asked this question i searched like for a week or so for its solution so i ...
.net asp.net-mvc asp.net-mvc-5 entity-framework linq
asked by a7madx7

Entity Framework : The model backing the 'EFDbContext' context has changed since the database was created

You can turn on debugger, i would assume the exception will stop at one the dbcontext or dbset, and inspect the dbcontext or dbset variable, find its dbcontext object , and inspect base -> Database -> connectionstring property, then you should see which database it is complaining. Looks like you are deleting the wrong database.
asp.net-mvc c# dbcontext entity-framework entity-framework-6
asked by anIBMer

The model backing the 'DataContext' context has changed since the database was created

I am not sure if you found the answer to your problem, but this other answer I found here actually did it for me: ...Entity Framework model change error...I actually ended up deleting the ...__MigrationHistory... table in SQL Server which I didn't know it was being created automatically....The article also talks about the option to not generate it ...
ef-code-first ef-migrations entity-framework
asked by Oscar

Entitiy Framework context.Database.ExecuteSqlCommand won't save changes to DB

These two ways to write to the database are almost two different worlds....The core function of an Object-Relational Mapper (ORM) like Entity Framework is to keep an object model (for example in C#) and a relational database model in sync with one another. Therefore it is capable of tracking changes in the object model and writing these changes to ...
entity-framework-6 sql-server
asked by Gert Arnold

What causes The model backing the 'ApplicationDbContext' context has changed since the database was created

Entity Framework stores migration history and the state of your database model in a table called MigrationHistory....This document has details on customizing that table....I suggest not modifying this, however. Instead, as a workaround, you can add a new migration, delete whatever content is inside of the ...Up()... method, and then update your dat...
c# entity-framework entity-framework-6
asked by Jim Yarbro

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow