How Can I Use Where Condition Inside Include In Entity Framework

See more:

LINQ

MVC

C#5.0

EF6.0

Hi All,


I am trying to use where condition inside include in an entity framework query as below.

var results = _courseService.QueryCourses()
                .Include(x => x.Language)
                .Include(x => x.Versions.Where(u=>u.Overwrite==null).Select(y => y.Language))
                .Include(x => x.Categories.Select(y => y.Category))
                .Include(x => x.CourseProvider)
                .Where(x => !x.IsDeleted && x.CourseProvider.Organisation.OrganisationID == CurrentUser.ActingAs.Value);

and when i am executing i am getting the below error:

An exception of type 'System.ArgumentException' occurred in EntityFramework.dll but was not handled in user code

Additional information: The Include path expression must refer to a navigation property defined on the type. Use dotted paths for reference navigation properties and the Select operator for collection navigation properties.


can any one help me how to fix this.

Thanks,
Anil