How do i get foreign key table data using Entity Framework and Web Api in Asp.Net MVC

Question

My Code is :

public class EmployeeController : ApiController
    {
        ASITDbEntities db = new ASITDbEntities ( );
        // GET api/employee
        public IEnumerable<Employee> Get ( )
        {
            db.Configuration.ProxyCreationEnabled = false;
            var result=db.Employees.ToList ()
            return result.ToList ( );
        }
}

I want to return employee district name from District table. It returns only district Id.

I tried db.Employee.Include(e=>e.district).Tolist(); But that did not work. Please help me.

"But did not work" What happened instead? Was there an error message? What are you expecting for the final result? — Jasen
– Jasen, Commented Nov 20, 2018 at 18:29
db.Employees.Include(e=>e.district).Tolist(); shouuld do the trick unless there isn't actually a value set in the database for the districtId. — Cristian Szpisjak
– Cristian Szpisjak, Commented Nov 20, 2018 at 18:42
I Used It ,var result = db.Employees.Include ( e => e.district ).ToList ( ); it shows this error ,"A specified Include path is not valid. The EntityType 'ASITDbModel.Employee' does not declare a navigation property with the name 'district'." — Md Abdul Mannan
– Md Abdul Mannan, Commented Nov 20, 2018 at 18:50
You should show the relevant parts of the class model. If Employee has something like DistrictId it's almost certain that you can add a navigation property District to it. — Gert Arnold
– Gert Arnold, Commented Nov 20, 2018 at 21:02

Madhu · Accepted Answer · 2018-11-20 18:50:40Z

1

Firstly are you using DB first or Code-first. If code first, Does your entities looks like this?

Public class Employee{
  public int EmpId {get;set;}
  public int EmpName {get;set;}

  public int DistrictId {get;set;}
  public District District {get;set;}
}

public class District{
  public int DistrictId {get;set;}

  public List<Employee> Employees {get;set;}
}

It creates 1-1 relationship between Employee and District entities. So, now if you include db.Employee.Include(e=>e.district).Tolist(), should return you the complete District object.

answered Nov 20, 2018 at 18:50

Madhu

4591 gold badge5 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

How do i get foreign key table data using Entity Framework and Web Api in Asp.Net MVC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related