c# - 属性上的 Entity Framework ForeignKeyAttribute … 类型上的 … 无效

Question

我收到这个错误:

The ForeignKeyAttribute on property 'SubdivisionsHOA' on type 'HealthOfAustralia.DAL.Models.ContentArticleHOAsubdivision' is not valid. The foreign key name 'SubdivisionHOAId' was not found on the dependent type 'HealthOfAustralia.DAL.Models.SubdivisionHOA'. The Name value should be a comma separated list of foreign key property names.

这是模型类:

public partial class ContentArticleHOAsubdivision
{
    public int Id { get; set; }
    public long ContentArticleId { get; set; }
    public short SubdivisionHOAId { get; set; }

    [ForeignKey("ContentArticleId")]
    public virtual ContentArticleHOA ContentArticleHOA { get; set; }
    [ForeignKey("SubdivisionHOAId")]
    public virtual ICollection<SubdivisionHOA> SubdivisionsHOA { get; set; }
}

public partial class SubdivisionHOA
{
    [Key, ForeignKey("TopTierDivisionHOA")]
    public short Id { get; set; }
    public string Name { get; set; }

    public virtual TopTierDivisionHOA TopTierDivisionHOA { get; set; }
}

我做错了什么？

Answer 1

您需要选择一对多关系并使用以下代码:

public class ContentArticleHOAsubdivision
{
     ...Comment this
     //public short SubdivisionHOAId { get; set; }
     ...
     [InverseProperty(" create property for ContentArticleHOAsubdivision on SubdivisionHOA")]
     public virtual ICollection<SubdivisionHOA> SubdivisionsHOA { get; set; }
}

或一对一与这个:

[ForeignKey("SubdivisionHOA")]
public short SubdivisionHOAId { get; set; }

public virtual SubdivisionHOA SubdivisionsHOA { get; set; }