将User实体Id作为Customer与OrderPicker关联键时数据种子报错排查

我开发了一个订单系统，包含Customer和OrderPicker两个角色，二者均需通过User实体完成身份验证。我希望将User的Id属性作为Customer与OrderPicker关联关系中的键，让User通过Id关联对应Customer或OrderPicker。我通过DataGenerator类初始化数据库种子数据，示例种子数据如下：

Users: 
    [
   {
      "Id":"guid_a",
      "Role":"Customer",
      "Password":"pwd_a"
   },
   {
      "Id":"guid_b",
      "Role":"Picker",
      "Password":"pwd_b"
   }
]

Customers:   
[
   {
      "Id":"guid_a",
      "Name":"customer_name"
   }
]   

OrderPickers:
[
   {
      "Id":"guid_b",
      "Name":"picker_name"
   }
]

我编写了如下实体类与配置代码：

public class User
{
    [Key]
    public Guid Id { get; private set; }
    public virtual Customer? Customer { get; private set; }
    public virtual OrderPicker? OrderPicker { get; private set; }
    [Required]
    public string Role { get; private set; }
    [Required]
    [DataType(DataType.Password)]
    [StringLength(8)]
    public string Password { get; private set; }
}
public class OrderPicker
{
    [Key, ForeignKey(nameof(User))]
    public Guid Id { get; private set; }
    public virtual User User { get; set; }
    [Required]
    public string Name { get; private set; }
    public ICollection<Order>? Orders { get; private set; } = new List<Order>();
}
public class Customer
{
    [Key, ForeignKey(nameof(User))]
    public Guid Id { get; private set; }
    public virtual User User { get; set; }

    [Required]
    public string Name { get; private set; }
    [Required]
    public string Address { get; private set; }
    [Required]
    [DataType(DataType.PhoneNumber)]
    public string Phone { get; private set; }
    [Required]
    [DataType(DataType.EmailAddress)]
    public string Email { get; private set; }
    public ICollection<Order>? Orders { get; private set; } = new List<Order>();
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);

    DataGenerator.InitData();

    modelBuilder
      .Entity<User>()
      .HasOne(u => u.Customer)
      .WithOne(c => c.User);
    modelBuilder
      .Entity<User>()
      .HasOne(u => u.OrderPicker)
      .WithOne(oi => oi.User);
    modelBuilder.Entity<User>().HasData(DataGenerator.Users);
    modelBuilder.Entity<Customer>().HasData(DataGenerator.Customers);
    modelBuilder.Entity<OrderPicker>().HasData(DataGenerator.OrderPickers);
}

运行后出现错误：

The seed entity for entity type 'Customer' cannot be added because another seed entity with the key value 'Id:some_alphanumeric_guid' has already been added.

请问我哪里配置错误？

错误原因 #

EF Core处理一对一共享主键关联时，需要明确指定哪个实体是依赖方（即使用自身主键作为外键关联主实体）。你当前的配置只声明了一对一关系，但没有指定外键映射规则，EF Core会自动生成额外的外键列，而非使用共享主键。这会导致种子数据插入时，EF Core误判为重复主键或关联关系冲突。另外，若种子数据中的Id是guid_a这类占位符而非有效Guid，也可能触发类似错误。

解决步骤 #

1. 明确指定共享主键关联规则
   在配置一对一关系时，用HasForeignKey指定Customer和OrderPicker的主键作为外键关联User：

   modelBuilder.Entity<User>()
      .HasOne(u => u.Customer)
      .WithOne(c => c.User)
      .HasForeignKey<Customer>(c => c.Id);
   
   modelBuilder.Entity<User>()
      .HasOne(u => u.OrderPicker)
      .WithOne(oi => oi.User)
      .HasForeignKey<OrderPicker>(oi => oi.Id);
   

2. 替换有效Guid作为种子数据ID
   将DataGenerator中的guid_a、guid_b替换为真实的Guid字符串，比如"550e8400-e29b-41d4-a716-446655440000"，避免EF Core解析无效ID导致的冲突误报。

3. 检查种子数据唯一性
   确保Customers和OrderPickers的Id与Users的Id一一对应，且没有重复的主键记录。

修正后的OnModelCreating代码 #

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

    DataGenerator.InitData();

    // 配置User与Customer的共享主键一对一关联
    modelBuilder.Entity<User>()
        .HasOne(u => u.Customer)
        .WithOne(c => c.User)
        .HasForeignKey<Customer>(c => c.Id);

    // 配置User与OrderPicker的共享主键一对一关联
    modelBuilder.Entity<User>()
        .HasOne(u => u.OrderPicker)
        .WithOne(oi => oi.User)
        .HasForeignKey<OrderPicker>(oi => oi.Id);

    modelBuilder.Entity<User>().HasData(DataGenerator.Users);
    modelBuilder.Entity<Customer>().HasData(DataGenerator.Customers);
    modelBuilder.Entity<OrderPicker>().HasData(DataGenerator.OrderPickers);
}

这样配置后，EF Core就能正确识别共享主键的关联逻辑，种子数据插入时不会再出现主键冲突错误。

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