Get specific object in list in Entity Framework

Question

I have a department object, and that object contains a list of employees. How do I get a department that a specific employee works in? I have a generic FindAll

IQueryable<Department> FindAll(params Expression<Func<Department, object>>[] includeProperties)

I then tried

FindAll().Where(x => x.Employee.Any(y => y.Name == name)).FirstOrDefault();

Im guessing .Name is a String. Should it not be y.Name.Equals(name) — clD
– clD, Commented Dec 8, 2015 at 9:51
Aren't there any built in function in entity framework like Find()? — Amit Kumar Ghosh
– Amit Kumar Ghosh, Commented Dec 8, 2015 at 9:56

A.Ima · Accepted Answer · 2015-12-08 11:02:40Z

2

Do you want to load a related entity?

You could do this:

    var employee = context.Employee.FirstOrDefault(y=>y.Name==name);
    if(employee!=null)
    {
      context.Entry(employee).Reference("Department").Load();
      var deparment = employee.Department;
    }

edited Dec 8, 2015 at 11:02

answered Dec 8, 2015 at 10:16

A.Ima

2666 silver badges13 bronze badges

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

1 Comment

Gary McGill Over a year ago

Shouldn't that be context.Entry(employee) (lower-case e on employee)? And shouldn't it be var department = employee.Department?

Collectives™ on Stack Overflow

Get specific object in list in Entity Framework

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related