sql server - EF Code first, how to register same table name with different schema?

Question

We are using Entity Framework, Code First and in our database we have several tables that have the same name but in different Schemas.

I have also put the models in two different namespaces.

How i can register these tables in my DbContext class?

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<Data.Schema1.Contact>().ToTable("Contact", "schema1");
    modelBuilder.Entity<Data.Schema2.Contact>().ToTable("Contact", "schema2");
}

Thanks for your help in advance!

Answer 1

Your classes must have different name or you must use separate context for every schema.

The reason for this is EDM model used internally. Even if you are using code-first it still creates EDM model on behind and it must follow all its restrictions and the way how POCO classes are matched to entities defined in CSDL model. Entities from EDM are and POCO classes are matched by class name (without namespaces). Because of that each class name mapped in the same context must be unique and different namespace doesn't make it different class name.