Linq Filtering Question <p>Guys actually i wanna make a query like this:</p> <pre><code>var firstTakeIssues = _db.Query&lt;Issue&gt;().OrderByDescending(i =&gt; i.CreatedDate) .Take(take) .Having(i =&gt; i.Project.ProjectID in IEnumerable&lt;int&gt;) .Select(i =&gt; new { IssueId = i.IssueID, State = (StateEnum)i.State, ProjectName = i.Project.Name, Priority = (PriorityEnum)i.Priority, CreatedAt = i.CreatedDate, PostedBy = i.Client.Name }).ToList(); </code></pre> <p>I know that this dont work, but what i want to do is:</p> <ol> <li>search by projects in a collection</li> <li>order by created date</li> <li>select just a set of data</li> <li>obtain a subset of columns</li> </ol> <p>What i really want to point is that i dont know how to make a query with having clause.</p>