How do I enable EF migrations for multiple contexts to separate databases?

.net entity-framework entity-framework-5 database-migration
aknuds1 picture aknuds1 · Nov 20, 2012 · Viewed 102.7k times · Source

How do I enable Entity Framework 5 (version 5.0.0) migrations for multiple DB contexts in the same project, where each context corresponds to its own database? When I run Enable-Migrations in the PM console (Visual Studio 2012), there's an error because of there being multiple contexts:

PM> Enable-Migrations
More than one context type was found in the assembly 'DatabaseService'.
To enable migrations for DatabaseService.Models.Product1DbContext, use Enable-Migrations -ContextTypeName DatabaseService.Models.Product1DbContext.
To enable migrations for DatabaseService.Models.Product2DbContext, use Enable-Migrations -ContextTypeName DatabaseService.Models.Product2DbContext.

If I run Enable-Migrations -ContextTypeName DatabaseService.Models.Product1DbContext I'm not allowed to run Enable-Migrations -ContextTypeName DatabaseService.Models.Product2DbContext because a migration already exists: Migrations have already been enabled in project 'DatabaseService'. To overwrite the existing migrations configuration, use the -Force parameter.

Answer

ckal picture ckal · Nov 20, 2012

The 2nd call to Enable-Migrations is failing because the Configuration.cs file already exists. If you rename that class and file, you should be able to run that 2nd Enable-Migrations, which will create another Configuration.cs.

You will then need to specify which configuration you want to use when updating the databases.

Update-Database -ConfigurationTypeName MyRenamedConfiguration

Related questions

EF LINQ include multiple and nested entities

Ok, I have tri-leveled entities with the following hierarchy: Course -> Module -> Chapter Here was the original EF LINQ statement: Course course = db.Courses .Include(i => i.Modules.Select(s => s.Chapters)) .Single(x => …

Read More
EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata

I have this error message that keeps on displaying every time I run the application. I'm using Entity Framework 5: Code First Here's the error message, System.NotSupportedException: Model compatibility cannot be checked because the database does not contain model metadata. …

Read More
Entity Framework Multiple Column as Primary Key by Fluent Api

These are my simplified domain classes. public class ProductCategory { public int ProductId { get; set; } public int CategoryId { get; set; } public virtual Product Product { get; set; } public virtual Category Category { get; set; } } public class Product { public int Id { get; set; } public …

Read More