在OnModelCreating中为EF核心创建一个用户和角色

public class User
{
    public int Id { get; set; }
    public string Username { get; set; }
    public string Password { get; set; }
    // 其他用户属性...
}

public class Role
{
    public int Id { get; set; }
    public string Name { get; set; }
    // 其他角色属性...
}

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<User>()
        .HasMany(u => u.Roles)
        .WithMany()
        .UsingEntity<Dictionary<string, object>>(
            "UserRoles",
            j => j.HasOne<Role>().WithMany().HasForeignKey("RoleId"),
            j => j.HasOne<User>().WithMany().HasForeignKey("UserId"),
            j =>
            {
                j.Property("CreatedAt").HasDefaultValueSql("GETDATE()");
                j.HasKey("UserId", "RoleId");
            }
        );
}

dotnet ef migrations add InitialCreate
dotnet ef database update