EF Code First Migration with Multiple Database / DbContext

entity-framework code-first entity-framework-migrations multiple-databases
seano288 picture seano288 · May 9, 2012 · Viewed 9.2k times · Source

I have two database each with their own dbcontext. I've setup two migration configurations. I can add a migration for the first db ust fine (Add-Migration DB1_InitialCreate -ConfigurationTypeName DB1Configuration). When I try to create an initial migration with the second db using: Add-Migration DB2_InitialCreate -ConfigurationTypeName DB2Configuration, I get the following error:

Unable to generate an explicit migration because the following explicit migrations are pending: [201205082215265_DB1_InitialCreate]. Apply the pending explicit migrations before attempting to generate a new explicit migration.

So I do what it says and update the database with: 

Update-Database -ConfigurationTypeName DB1Configuration

Then I try to add a migration again for the second db but I keep getting the same error.

Any ideas on how to get migrations working for two databases/contexts?

Answer

seano288 picture seano288 · May 9, 2012

I've been able to answer my own question. My two configuration classes existed in the same namespace. As soon as I separated them, everything worked.

Related questions

C# Code-First migration, up/down?

Started to use the add-migration command in the package manager console to generate the migrations for my model. My question is, the up and down method. I assume that the purpose of the down method is to remove all dependencies …

Read More
How to run Seed() method of Configuration class of migrations

I have 2 questions: 1) How can I run Seed() method from the package-manager console without updating-database model? 2) Is there a way how to call Seed() method in the code? Thx for any advice.

Read More
Adding CreatedDate to an entity using Entity Framework 5 Code First

I am trying to add a CreatedDate property to entities in my Model and am using EF5 Code First. I want this date to not be changed once set, I want it to be a UTC date. I do NOT …

Read More