c# - 在 Entity Framework Code First 中执行启用迁移时出错

Question

我正在尝试在 Person 和 Car 之间创建 1:many 关系。我知道这是微不足道的。但是在包管理器控制台中传递 Enable-Migrations 时，我得到了这个:

Car_Person_Target_Car_Person_Source: : The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property 'PersonID' on entity 'Car' does not match the type of property 'FirstName' on entity 'Person' in the referential constraint 'Car_Person'.

Car_Person_Target_Car_Person_Source: : The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property 'PersonSsn' on entity 'Car' does not match the type of property 'LastName' on entity 'Person' in the referential constraint 'Car_Person'.

人类:

public class Person
{
    public Person()
    {
        Cars = new List<Car>();
    }
        [Key, Column(Order = 0)]
        public int ID { get; set; }
        [Key, Column(Order = 1)]
        public int Ssn { get; set; }
        public int Age { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }

        public virtual ICollection<Car> Cars { get; set; }  
}

汽车类:

public class Car
{        
    [Key, Column(Order = 0)]
    public int ID { get; set; }
    [Key, Column(Order = 1)]
    public int ChassisSerial { get; set; }

    [ForeignKey("Person"), Column(Order = 0)]
    public int? PersonID { get; set; }
    [ForeignKey("Person"), Column(Order = 1)]
    public int? PersonSsn { get; set; }

    public virtual Person Person { get; set; }
}

提前致谢。

Answer 1

将外键的类型改为“int”，必须与Person的PK类型匹配

public class Car
{        
    [Key, Column(Order = 0)]
    public int ID { get; set; }
    [Key, Column(Order = 1)]
    public int ChassisSerial { get; set; }

    [ForeignKey("Person"), Column(Order = 0)]
    public int PersonID { get; set; }
    [ForeignKey("Person"), Column(Order = 1)]
    public int PersonSsn { get; set; }

    public virtual Person Person { get; set; }
}