CODEWITHSUNDEEP
c#entity-framework
Chris Halcrow
Chris Halcrow

Reputation: 31950

Entity Framework 6 - foreign key issue

I have the following model using EF6, where I'm trying to link a 'ContentArticleHOAsubdivision' entity to a 'SubdivisionHOA':

public partial class ContentArticleHOAsubdivision
{
    public int Id { get; set; }
    [ForeignKey("ContentArticleHOA")]
    public long ContentArticleId { get; set; }
    [ForeignKey("SubdivisionsHOA")]
    public short SubdivisionId { get; set; }

    public virtual ContentArticleHOA ContentArticleHOA { get; set; }
    public virtual ICollection<SubdivisionHOA> SubdivisionsHOA { get; set; }
}

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

    public virtual TopTierDivisionHOA TopTierDivisionHOA { get; set; }
}

I get the error:

The foreign key component 'SubdivisionId' is not a declared property on type 'SubdivisionHOA'. Verify that it has not been explicitly excluded from the model and that it is a valid primitive property.

The 'Id' property in SubdivisionHOA I'm trying to link on needs to be named 'Id' as that's the name of the actual column in the database, so I'm not sure what I need to do?

I've tried adding [InverseProperty("Id")] before the [ForeignKey] attributes but get the same error.

Upvotes: 0

Views: 281

Answers (1)

Jerry Bian
Jerry Bian

Reputation: 4238

Basicly the foreign key usage in EntityFramework seems like this:

public partial class ContentArticleHOAsubdivision
{
    public int Id { get; set; }

    ...

    public virtual ICollection<SubdivisionHOA> SubdivisionsHOAs { get; set; }
}

public partial class SubdivisionHOA
{
    public short Id { get; set; }

    ...

    public int ContentArticleHOAsubdivisionId { get; set; }

    [ForeignKey("ContentArticleHOAsubdivisionId")]
    public virtual ContentArticleHOAsubdivision ContentArticleHOAsubdivision { get; set; }
}

Just based on your code, and I have discard some unknown stuffs.

Upvotes: 1

Related Questions