Entity Framework not populating context

Posted by stimms on Stack Overflow See other posts from Stack Overflow or by stimms
Published on 2010-06-15T18:23:28Z Indexed on 2010/06/15 18:32 UTC
Read the original article Hit count: 216

I'm just starting out with some entity framework exploration, I figured it was time to see what everybody was complaining about. I am running into an issue where the entities don't seem to be returning any of the object context. I generated the model from a database with three tables which link to one another.

Courses
Instructors
CanTeach

Relationships are as you would expect: a course can relate to multiple CanTeach entities and an instructor can also relate to multiple CanTeach entities. I also added an OData service to my project which also makes use of the same model. So I can run queries like

from a in CanTeach
where a.Instructor.FirstName == "Barry"
select new { Name = a.Instructor.FirstName + " " + a.Instructor.LastName,
   Course = a.Course.Name}

without issue against the OData endpoint using LINQPad. However when I do a simple query like

public Instructor GetInstructorFromID(int ID)
{
    return context.Instructors.Where(i => i.ID == ID).FirstOrDefault();
}

The CanTeach list is empty. I know everything in EF is lazy loaded and it is possible that my context is out of scope by the time I look at the object context, however even trying to get the object context as soon as the query is run results in and empty object context.

What am I doing wrong?

© Stack Overflow or respective owner

Related posts about asp.net-mvc

Related posts about entity-framework