使用映射表进行多对多关系映射

Question

我有下表

Users
-> UserId
-> Name

Roles
-> RoleId
-> Name

UserRoles
-> UserId
-> RoleId

和以下类

public class Role{
     public int RoleId{get;set;}
     public int Name{get;set;}
}

public class User{
     public int UserId{get;set;}
     public int Name{get;set;}
     public ICollection<Role> Roles{get;set;}
}

如何使用 EntityFramework ModelBinder 映射它。

Answer 1

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<User>()
        .HasMany(u => u.Roles)
        .WithMany()
        .Map(a => {
            a.ToTable("UserRoles");
            a.MapLeftKey("UserId");
            a.MapRightKey("RoleId");
        });
}