Foreignkey Name error in Entity Framework Code First

Question

When I'm using the following code, the tables are generated successfully with the Primary key and Foreign Key relations.

 [Table("tblDepartments")]
    public class DepartmentModel
    {
        [Key]
        public int DepartmentID { get; set; }
        public string Name { get; set; }
        public string Location { get; set; }
        public ICollection<EmployeeModel> Employees { get; set; }
    }



    [Table("tblEmployees")]
    public class EmployeeModel
    {
        [Key]
        public int EmployeeID { get; set; }
        public string Name { get; set; }
        public string Gender { get; set; }
        public string City { get; set; }      
        public virtual DepartmentModel DID { get; set; }

    }

But when I use the following Code, I'm Getting error:

[Table("tblDepartments")]
    public class DepartmentModel
    {
        [Key]
        public int DepartmentID { get; set; }
        public string Name { get; set; }
        public string Location { get; set; }
        public ICollection<EmployeeModel> Employees { get; set; }
    }



    [Table("tblEmployees")]
    public class EmployeeModel
    {
        [Key]
        public int EmployeeID { get; set; }
        public string Name { get; set; }
        public string Gender { get; set; }
        public string City { get; set; }     

        [ForeignKey("DeptID")]
        public virtual DepartmentModel DID { get; set; }

    }

ERROR:

The ForeignKeyAttribute on property 'DID' on type 'MvcApplication1.Models.EmployeeModel' is not valid. The foreign key name 'DeptID' was not found on the dependent type 'MvcApplication1.Models.EmployeeModel'. The Name value should be a comma separated list of foreign key property names.

Please Help. Thanks in advance.

Look carefully what the message says: The Name value should be a comma separated list of foreign key property names. You can use this attribute when DeptID is a property of EmployeeModel. — Gert Arnold
– Gert Arnold, Commented Jul 1, 2015 at 11:39

Piotr Kula · Accepted Answer · 2017-01-23 23:31:59Z

10

The problem is with your EmployeeModel as you are missing departmentid field in your table as suggested by Gert. you can use the below for EmployeeModel

[Table("tblEmployees")]
public class EmployeeModel
{
    [Key]
    public int EmployeeID { get; set; }
    public string Name { get; set; }
    public string Gender { get; set; }
    public string City { get; set; }     
    public int DeptID { get; set; } //<-- You forgot to add this
    [ForeignKey("DeptID")]
    public virtual DepartmentModel DID { get; set; }

}

edited Jan 23, 2017 at 23:31

Piotr Kula

9,8918 gold badges62 silver badges88 bronze badges

answered Jul 1, 2015 at 11:48

Dinesh Kumar

1866 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

yohannist · Accepted Answer · 2015-07-01 11:47:46Z

4

Put the foreign key as a property inside your model then have the navigation property point to it.

public class EmployeeModel
    {
        [Key]
        public int ID { get; set; }
        public int DeptID { get; set; }
        public string Name { get; set; }
        public string Gender { get; set; }
        public string City { get; set; }     

        [ForeignKey("DeptID")]
        public virtual DepartmentModel DID { get; set; }

    }

answered Jul 1, 2015 at 11:47

yohannist

4,2143 gold badges38 silver badges59 bronze badges

Comments

bubi · Accepted Answer · 2015-07-01 13:50:43Z

0

In '[ForeignKey("DeptID")]' you need to have the property DeptID in the model. If you don't want it but just the name DeptID on the foreign key field you need to use fluent interface to configure the relationship i.e.

        HasOptional(t => t.DID)
            .WithMany()
            .Map(d => d.MapKey("DeptID"));

answered Jul 1, 2015 at 13:50

bubi

6,5013 gold badges32 silver badges50 bronze badges

Collectives™ on Stack Overflow

Foreignkey Name error in Entity Framework Code First

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related