How to specify a schema for a many-to-many relationship table?

Question

I have a User-Role many-to-many relationship, specified by this excerpt from an EntityTypeConfiguration<Role> derived class that allows me to specifiy schemas for single tables, e.g:

[Schema(SchemaNames.ParkPay)]
class WeekDayConfig : EntityTypeConfigurationWithSchema<WeekDay>
{
    internal WeekDayConfig()
    {
        Ignore(t => t.IsDeleted);
        Property(p => p.Name)
            .IsRequired()
            .HasMaxLength(20);
    }
}

Now, for Role, the configuration class contains this code, and the resultant table UserRole gets created under the 'dbo' schema, not my desired schema. This is that code:

[Schema(SchemaNames.ParkPay)]
internal class RoleConfig : EntityTypeConfigurationWithSchema<Role>
{
    public RoleConfig()
    {
        HasMany(t => t.Users)
            .WithMany(t => t.Roles)
            .Map(m =>
                     {
                         m.ToTable("UserRole");                            
                         m.MapLeftKey("RoleId");
                         m.MapRightKey("UserId");
                     });
    }
}

Is there anything I can do, except script a schema change during the seeding phase of initialization, to have table UserRole created under the 'parkpay' schema and not the 'dbo' schema?

Did you try this? Looks like an overload of `ToTable`: http://stackoverflow.com/questions/6028375/entity-framework-code-first-many-to-many-setup-for-existing-tables — rliu, Jun 14 '13 at 16:54

score 11 · Accepted Answer · answered Jun 14 '13 at 17:35

11

I don't see why this wouldn't work:

public RoleConfig()
{
    HasMany(t => t.Users)
    .WithMany(t => t.Roles)
    .Map(m =>
    {
        m.ToTable("UserRole","parkpay");                            
        m.MapLeftKey("RoleId");
        m.MapRightKey("UserId");
    });
}

answered Jun 14 '13 at 17:35

SOfanatic

5,523
5
36
57

1

Neither do I, and it does. Thanks, I missed that overload. – ProfK Jun 14 '13 at 17:42
1

Is there a DataAnnotations way of doing this? – RoLYroLLs Feb 21 '18 at 04:05

How to specify a schema for a many-to-many relationship table?

1 Answers1

Linked