EF - How to define foreign key which is the primary key of the current table

Question

I have table name is Grades which have a column name Upgrade refer to value which is will be one of the values of the primary key in the table Grades - same table- I try to do this like the following code

public class Grades
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public Grades UpGrade { get; set; }
        public int UpGradeId { get; set; }
    }

score 0 · Accepted Answer · answered Aug 03 '19 at 14:20

[ForeignKey] attribute should work just as well for self-referencing FKs as it works for regular ForeignKeys

public class Grades
{
    public int Id { get; set; }
    public string Name { get; set; }
    [ForeignKey("UpGradeId")]
    public Grades UpGrade { get; set; }
    public int UpGradeId { get; set; }
}

EF - How to define foreign key which is the primary key of the current table

1 Answers1