c# - Entity Framework 关系映射中的错误

Question

我得到了以下 EF6 映射

namespace Model
{
    [Serializable]
    [Table("PROVISION")]
    public class Provision
    {
        [Key, Column("ID_PROVISION", Order = 1), DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public virtual long Id { get; set; }

        [Column("ID_PROVISION_TYPE")]
        public virtual int IdProvisionType { get; set; }

        [ForeignKey("IdProvisionType")]
        public virtual ProvisionType ProvisionType { get; set; }
    }

    public class ProvisionType 
    {
        [Key, Column("ID_PROVISION_TYPE", Order = 1), DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
    }
}

但是，我收到以下错误:

Provision_ProvisionType_Target_Provision_ProvisionType_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 'Id' on entity 'Provision' does not match the type of property 'Id' on entity 'ProvisionType' in the referential constraint 'Provision_ProvisionType'.

如您所见，外键和引用的主键是同一类型。问题是它在 EF4 上运行良好，但是当我更新到 EF6 时，我开始收到此错误，并且系统很大并且充满了相同的场景。

编辑:忘了说这是一个 .net 4.0 项目

有人知道解决办法吗？

Answer 1

ID_PROVISION 是主键，所以 ForeignKey 使用 ID_PROVISION 中的 id 对 id ID_PROVISION_TYPE 键(键对键)，所以你必须定义相同的类型。

试试这个:

namespace Model
{
    [Serializable]
    [Table("PROVISION")]
    public class Provision
    {
        [Key, Column("ID_PROVISION", Order = 1), DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public virtual long Id { get; set; }

        [Key,Column("ID_PROVISION_TYPE")]
        public virtual int IdProvisionType { get; set; }

        [ForeignKey("IdProvisionType")]
        public virtual ProvisionType ProvisionType { get; set; }
    }

    public class ProvisionType 
    {
        [Key, Column("ID_PROVISION_TYPE", Order = 1), DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
    }
}