c# - EF Core - 复合主键删除一个索引

问题描述

我有这个实体：

[Table("order")]
public class Order
{
    [Key]
    [Column("id")]
    public Guid Id { get; set; }

    [MaxLength(128)]
    [Column("description")]
    public string Description { get; set; }

    [ForeignKey("Student")]
    [Column("student_id")]
    public Guid StudentId { get; set; }

    [ForeignKey("Employer")]
    [Column("employer_id")]
    public Guid EmployerId { get; set; }

    [ForeignKey("Customer")]
    [Column("customer_id")]
    public Guid CustomerId { get; set; }

    public virtual Guid Student { get; set; }
    public virtual Guid Employer { get; set; }
    public virtual Guid Customer { get; set; }
}

我看到了下一个快照DbContext：

modelBuilder.Entity("DataInterface.Models.Order", b =>
{
    b.Property<Guid>("Id")
        .ValueGeneratedOnAdd()
        .HasColumnName("id");

    b.Property<string>("Description")
        .HasColumnName("description")
        .HasMaxLength(128);

    b.Property<Guid>("StudentId")
        .HasColumnName("student_id");

    b.Property<Guid>("EmployerId")
        .HasColumnName("employer_id");

    b.Property<Guid>("CustomerId")
        .HasColumnName("customer_id");

    b.HasKey("Id");

    b.HasIndex("StudentId");

    b.HasIndex("EmployerId");

    b.HasIndex("CustomerId");

    b.ToTable("order");
});

你怎么能看到 - 一切都很好。但我需要创建一个复合键并删除主键。所以，让我们去做吧。我的实体新代码（没有Id主键）：

[Table("order")]
public class Order
{
    [MaxLength(128)]
    [Column("description")]
    public string Description { get; set; }

    [ForeignKey("Student")]
    [Column("student_id")]
    public Guid StudentId { get; set; }

    [ForeignKey("Employer")]
    [Column("employer_id")]
    public Guid EmployerId { get; set; }

    [ForeignKey("Customer")]
    [Column("customer_id")]
    public Guid CustomerId { get; set; }

    public virtual Guid Student { get; set; }
    public virtual Guid Employer { get; set; }
    public virtual Guid Customer { get; set; }
}

OnModelCreating我在上下文的方法中添加了新行为：

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Order>()
        .HasKey(x => new { x.StudentId, x.EmployerId, x.CustomerId });
}

当我添加新迁移时，我看到索引已StudentId被删除。我不明白为什么？我的新快照DbContext：

modelBuilder.Entity("DataInterface.Models.Order", b =>
{
    b.Property<Guid>("Id")
        .ValueGeneratedOnAdd()
        .HasColumnName("id");

    b.Property<string>("Description")
        .HasColumnName("description")
        .HasMaxLength(128);

    b.Property<Guid>("StudentId")
        .HasColumnName("student_id");

    b.Property<Guid>("EmployerId")
        .HasColumnName("employer_id");

    b.Property<Guid>("CustomerId")
        .HasColumnName("customer_id");

    b.HasKey("StudentId", "EmployerId", "CustomerId");

    b.HasIndex("EmployerId");

    b.HasIndex("CustomerId");

    b.ToTable("order");
});

为什么删除了三个索引之一？为什么b.HasIndex("StudentId");行被删除？怎么了？

注意：我没有看到来自另一个表中两个字段的复合键的这个问题。

标签： c#entity-frameworkentity-framework-coreentity-framework-migrations

c# - EF Core - 复合主键删除一个索引

问题描述

解决方案

推荐阅读