Linq To Entities Generating Big Queries?

The large query LINQ to EF creates is just a shortcoming of the first release of the Entity Framework. However, your query contains the phrase . OrderBy(SortField + " " + SortOrder), I believe the preffered way to write this would be .

OrderBy(SortField). ThenBy(SortOrder). Also, is there any reason that you are using | instead of || and & instead of && in some places?

IQueryable tl = db. Tasks . Include("Catagories") .

Include("Projects") . Include("TaskStatuses") . Include("AssignedTo") .

Where (t => (t.TaskStatuses.TaskStatusId. Equals(currentStatus) | currentStatus == -1) & (t.Projects.ProjectId. Equals(projectId) | projectId == -1) & (t.Subject.

Contains(SearchText) | t.Description. Contains(SearchText) | SearchText == "" | SearchText == null) & (t.Projects. Active == true) & (t.Catagories.

Active == true || t. Catagories==null) & (t.LoggedBy.UserProfile.Companies. CompanyId == CompanyId) & (assignedToGuid == rnd | t.AssignedTo.UserId.

Equals(assignedToGuid))). OrderBy(SortField + " " + SortOrder).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.