asp.net - 自定义 ASP.NET Core 身份表

Question

当在asp.net core 2中自定义Identity类时，表之间的关系不会自动创建。

如何以最简单的方式创建表之间的关系？

用户类别:

public class User : IdentityUser<int>
{
    // codes
}

角色类别:

public class Role : IdentityRole<int>
{
    public Role() : base()
    {

    }
    public Role(string roleName) : base(roleName)
    {

    }
}

RoleClaim 类:

public class RoleClaim : IdentityRoleClaim<int> { }

UserClaim 类:

public class UserClaim : IdentityUserClaim<int> { }

UserLogin 类:

public class UserLogin : IdentityUserLogin<int> { }

UserRole 类:

public class UserRole : IdentityUserRole<int> { }

UserToken 类:

public class UserToken : IdentityUserToken<int> { }

我希望我的表之间有相同的关系:

Answer 1

我通过在User、Role、UserClaim、UserRole中编写一些代码来定义表的关系>、UserLogin、RoleClaim 和 UserToken 类以及 ApplicationDbContext 类。

角色类别:

public class Role : IdentityRole<int>
{
    public Role() : base()
    {

    }
    public Role(string roleName) : this()
    {
        Name = roleName;
    }

    public virtual ICollection<UserRole> Users { get; set; }
    public virtual ICollection<RoleClaim> Claims { get; set; }
}

RoleClaim 类:

public class RoleClaim : IdentityRoleClaim<int>
{
    public virtual Role Role { get; set; }
}

用户类别:

public class User : IdentityUser<int>
{
    public virtual ICollection<UserToken> UserTokens { get; set; }

    public virtual ICollection<UserRole> Roles { get; set; }

    public virtual ICollection<UserLogin> Logins { get; set; }

    public virtual ICollection<UserClaim> Claims { get; set; }
}

UserClaim 类:

public class UserClaim : IdentityUserClaim<int>
{
    public virtual User User { get; set; }
}

UserLogin 类:

public class UserLogin : IdentityUserLogin<int>
{
    public virtual User User { get; set; }
}

UserRole 类:

public class UserRole : IdentityUserRole<int>
{
    public virtual User User { get; set; }
    public virtual Role Role { get; set; }
}

UserToken 类:

public class UserToken : IdentityUserToken<int>
{
    public virtual User User { get; set; }
}

ApplicationDbContext 类:

public class ApplicationDbContext : IdentityDbContext<User, Role, int, UserClaim, UserRole, UserLogin, RoleClaim, UserToken>
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
    {

    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        modelBuilder.Entity<RoleClaim>(builder =>
        {
            builder.HasOne(roleClaim => roleClaim.Role).WithMany(role => role.Claims).HasForeignKey(roleClaim => roleClaim.RoleId);
            builder.ToTable("RoleClaim");
        });
        modelBuilder.Entity<Role>(builder =>
        {
            builder.ToTable("Role");
        });
        modelBuilder.Entity<UserClaim>(builder =>
        {
            builder.HasOne(userClaim => userClaim.User).WithMany(user => user.Claims).HasForeignKey(userClaim => userClaim.UserId);
            builder.ToTable("UserClaim");
        });
        modelBuilder.Entity<UserLogin>(builder =>
        {
            builder.HasOne(userLogin => userLogin.User).WithMany(user => user.Logins).HasForeignKey(userLogin => userLogin.UserId);
            builder.ToTable("UserLogin");
        });
        modelBuilder.Entity<User>(builder =>
        {
            builder.ToTable("User");
        });
        modelBuilder.Entity<UserRole>(builder =>
        {
            builder.HasOne(userRole => userRole.Role).WithMany(role => role.Users).HasForeignKey(userRole => userRole.RoleId);
            builder.HasOne(userRole => userRole.User).WithMany(user => user.Roles).HasForeignKey(userRole => userRole.UserId);
            builder.ToTable("UserRole");
        });
        modelBuilder.Entity<UserToken>(builder =>
        {
            builder.HasOne(userToken => userToken.User).WithMany(user => user.UserTokens).HasForeignKey(userToken => userToken.UserId);
            builder.ToTable("UserToken");
        });
    }
}

你可以在这张图中看到结果: