Manually updating database, EF complians model backing the context has changed

When I run my application it says the model backing my context has changed since the database was created.

I added a field to my model like:

  • ADO.NET SQLServer: How to prevent closed connection from holding S-DB lock?
  • Sql query to Group by day
  • What is the best way to handle bc dates in .net / sql server?
  • SQL Server: how do I find which column/row gave me an error?
  • SQL Server 2008 R2 to MySQL Migration
  • Assign daily work entries to contract dates without proper foreign keys
  • public int? LocationId {get;set;}
    

    I added an int column to the database, and it is nullable.

    I understand the database has that _migrationsHistory table that is now not in sync.

    What I have been doing so far in QA is just dropping all the tables and then running the application which just re-creates the database automatically for me.

    Now I want to keep the data in the table, how can I fix this issue?

    I added the column so it should work, but when it performs the validation during startup if fails.

    What options do I have?

  • Move emails to SQL Server
  • asp:QueryStringParameter and empty query string parameter
  • An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
  • Pass List as XElement to be used as XML Datatype parameter
  • How to ignore LINQ to SQL on unique key?
  • SqlTransaction has completed
  • One Solution collect form web for “Manually updating database, EF complians model backing the context has changed”

    It sounds like you want to use Code-First Migrations (EF 4.3 and later)

    This would allow you to generate migration files based on changes to the model via the Package Manager Console.

    you can generate a migration file by using add-migration <name>, make changes to it if required and use update-database to manually update.

    You can also roll-back to any migration point if you inadvertently break something.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.