MVC3 and Code First Migrations – “model backing the ‘blah’ context has changed since the database was created”

by

From my experience that suggests that migration table is out of sync (even if your data isn’t), and that’s been part of the db schema now (since 4.3 I think – under system tables).

There could be many reasons and ways to experience that error , but most of the time…

The problematic part is some combination of manually backing/restoring the full database with code changes alongside – I’m not entirely certain as to why always.

In short, even if Db-s are the same migration table data might not be – and hash comparison may fail (still full restore sounds like good enough – but you have ‘two sides’).

What works for me is to use
Update-Database -Script

That creates a script with a ‘migration difference’,
which you can manually apply as an SQL script on the target server database (and you should get the right migration table rows inserted etc.).

If that still doesn’t work – you can still do two things…

  1. Remove the migration table (target – under system tables) – as per http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-automatic-migrations-walkthrough.aspx comments in there – that should fail back to previous behavior and if you’re certain that your Db-s are the same – it’s just going to ‘trust you’,

  2. As a last resort I used – make a Update-Database -Script of the full schema (e.g. by initializing an empty db which should force a ‘full script’),
    find the INSERT INTO [__MigrationHistory] records,
    just run those, insert them into the database,
    and make sure that your databases – and code match,

that should make things run in sync again.

(disclaimer: this is not a bullet proof to work at all times, you may need to try a few things given your local scenarios – but should get you in sync)

More Related Contents:

  1. Reset Entity-Framework Migrations
  2. EntityFramework code-first custom connection string and migrations
  3. Create a Dropdown List for MVC3 using Entity Framework (.edmx Model) & Razor Views && Insert A Database Record to Multiple Tables
  4. Debug code-first Entity Framework migration codes
  5. Value cannot be null. Parameter name: entitySet
  6. Stuffing an anonymous type in ViewBag causing model binder issues
  7. EF Migrations: Rollback last applied migration?
  8. How can I disable migration in Entity Framework 6.0
  9. Nullable property to entity field, Entity Framework through Code First
  10. Best way to incrementally seed data in Entity Framework 4.3
  11. Entity Framework Code First Using Guid as Identity with another Identity Column
  12. AutomaticMigrationsEnabled false or true?
  13. Entity Framework Validation confusion – maximum string length of ‘128’
  14. Entity Framework Core 2.0 – Run migrations step by step
  15. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  16. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  17. Code First: Independent associations vs. Foreign key associations?
  18. Entity Framework 6 Code first Default value
  19. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  20. Querying objects after AddObject before SaveChanges?
  21. Entity Framework 4.1 default eager loading
  22. PropertyGrid Browsable not found for entity framework created property, how to find it?
  23. Entity framework PostgreSQL
  24. Loop/reflect through all properties in all EF Models to set Column Type
  25. Keyword not supported: “data source” initializing Entity Framework Context
  26. Entity Framework Data Annotations Set StringLength VarChar
  27. The type or namespace name ‘DbContext’ could not be found [closed]
  28. Entity Framework: Inheritance and Include
  29. Entity Framework – Get List of Tables
  30. Entity framework code first delete with cascade

Leave a Comment