Not finding .Include() method in my EF implementing Generic repository

Question

I am using Generic repository to wrap DbContext and DbSet classes from upper level. However, when in certain queries I need to use ".Include()" method to include navigation properties. But I am unable to find these methods on repository methods returing IQueryable

Like,

this.repository.GetQuery<GeneralCalendarDates>()

this doesn't have include method, though I can use .ToList() here.

Any idea what could be wrong here?

Answer 1

Include for IQueryable<T> is an extension method that is implemented in namespace System.Data.Entity in the assembly EntityFramework.dll. So your project must reference this assembly and you must add

using System.Data.Entity;

at the beginning of your code file. It will make the string and lambda based version of Include available, so that you can use:

orderQuery.Include("Customer")

or

orderQuery.Include(o => o.Customer)