Using Entity Framework 6 with Multiple DB Schemas but using One DBContext

You can map each table to its own schema by fluent mapping only. In your DbContext subtype you should override OnModelCreating (if you haven’t done so already) and add statements like this:

modelBuilder.Entity<Department>()  
    .ToTable("t_Department", "school");

Entities that you don’t map like this explicitly will be placed in the default dbo schema, or you can provide your own default by

modelBuilder.HasDefaultSchema("sales");

(summarized from here)

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)