在.Net内核/ EF内核中设置多个相同类别的外键

public class Product
{
    public int ProductId { get; set; }
    public string Name { get; set; }
    
    public int CategoryId1 { get; set; } // 第一个外键属性
    public int CategoryId2 { get; set; } // 第二个外键属性
    
    public Category Category1 { get; set; } // 第一个外键关联的导航属性
    public Category Category2 { get; set; } // 第二个外键关联的导航属性
}

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Product>()
        .HasOne(p => p.Category1)
        .WithMany(c => c.Products)
        .HasForeignKey(p => p.CategoryId1);

    modelBuilder.Entity<Product>()
        .HasOne(p => p.Category2)
        .WithMany(c => c.Products)
        .HasForeignKey(p => p.CategoryId2);
}

var product = new Product
{
    ProductId = 1,
    Name = "Product 1",
    CategoryId1 = 1,
    CategoryId2 = 2
};

context.Products.Add(product);
context.SaveChanges();