Jash Jash - 1 year ago 114
C# Question

How to update entity framework 7 migrations and database - Code first

In ef 7, i created an initial migration using command 'dnx ef migrations add Initial'. When i run the application database was created for me, all good.

Then i updated my entity objects (CSharp files). Now how can i do:

  1. Update the existing migrations ? (Or i have to add new one?)

  2. Update the already created database

I am getting error: An object already exists in database.

Also, any resources where i can find good practical examples for entity framework code first, as i am struggling to get to speed.


Answer Source

Looks like i figure it out:

  1. Add initial migration (our your first one). Command 'dnx ef migrations add Initial'

  2. Run the application which will create the database for you.

  3. Update your entity models (csharp classes)
  4. Add a new migration again. DO NOT DELETE existing migration. Command: 'dnx ef migrations add Migration2'

  5. Update your database. Command 'dnx ef database update Migration2 -v'

Hope it helps anyone.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download