EF Core多对多关系数据种子报错：无法添加UserRole实体

问题说明 #

使用Entity Framework Core初始化默认管理员用户并关联角色时，User和Role实体初始化成功，但UserRole多对多关联的种子数据抛出错误：

System.InvalidOperationException: 'The seed entity for entity type 'UserRole' cannot be added because it has the navigation 'Role' set. To seed relationships, add the entity seed to 'UserRole' and specify the foreign key values {'RoleId'}

错误原因 #

EF Core的HasData方法不支持在种子实体中直接赋值导航属性（如User、Role），必须通过外键字段（UserId、RoleId）来关联已预定义的实体。

修复方案 #

1. 移除UserRole种子实体中的导航属性赋值（User和Role）
2. 确保UserId和RoleId正确关联已创建的User、Role实体ID
3. 固定CreatedOn、UpdatedOn的初始值（避免每次迁移生成不同时间戳导致不必要的变更）

修改后的种子数据代码 #

public HiveSeedData(ModelBuilder modelBuilder)
{
    // 提前生成固定ID，方便关联
    var adminUserId = Guid.NewGuid().ToString();
    var adminRoleId = Guid.NewGuid().ToString();
    var taskRoleId = Guid.NewGuid().ToString();
    var seedTimestamp = DateTime.UtcNow;

    User adminUser = new User
    {
        Id = adminUserId,
        FirstName = "Default",
        LastName = "Administrator",
        EmailAddress = "admin@admin.com",
        Password = BCrypt.Net.BCrypt.HashPassword("admin")
    };

    Role adminRole = new Role
    {
        Id = adminRoleId,
        RoleName = "ADMINISTRATOR"
    };

    Role taskRole = new Role
    {
        Id = taskRoleId,
        RoleName = "USER"
    };

    UserRole adminToAdminRole = new UserRole
    {
        Id = Guid.NewGuid().ToString(),
        UserId = adminUserId,
        RoleId = adminRoleId,
        CreatedBy = "Hive_API",
        CreatedOn = seedTimestamp,
        UpdatedBy = "Hive_API",
        UpdatedOn = seedTimestamp
    };

    modelBuilder.Entity<User>().HasData(adminUser);
    modelBuilder.Entity<Role>().ToTable("Roles").HasData(adminRole, taskRole);
    modelBuilder.Entity<UserRole>().ToTable("UserRoles").HasData(adminToAdminRole);
}

额外优化建议 #

在UserRole模型中，可以为导航属性显式添加外键注解，让EF Core更明确地识别关联关系（可选，原模型已能被EF识别，但显式注解更清晰）：

[Required]
[MaxLength(36)]
[Column(TypeName = "varchar(36)")]
public string UserId { get; set; } = string.Empty;

[ForeignKey(nameof(UserId))]
[Required]
public User User { get; set; } = null;

[Required]
[MaxLength(36)]
[Column(TypeName = "varchar(36)")]
public string RoleId { get; set; } = string.Empty;

[ForeignKey(nameof(RoleId))]
[Required]
public Role Role { get; set; } = null;

内容的提问来源于stack exchange，提问作者Matt