query: Left Join on Linq query when also using the Where clause on joint table
positive_passages.docid: 156322
positive_passages.text: LINQ Inner-Join vs Left-Join
negative_passages.docid: 105907
negative_passages.text: EntityFieldQuery INNER JOIN
negative_passages.docid: 74867
negative_passages.text: Using dynamic where clauses in Entity Framework
negative_passages.docid: 96218
negative_passages.text: Using Distinct with LINQ and Objects
negative_passages.docid: 12261
negative_passages.text: Dynamic where clause (OR) in Linq to Entities
negative_passages.docid: 66242
negative_passages.text: Use LINQ to get items in one List, that are not in another List
negative_passages.docid: 130567
negative_passages.text: Difference between INNER JOIN and WHERE?
negative_passages.docid: 117991
negative_passages.text: The type of one of the expressions in the join clause is incorrect in Entity Framework
negative_passages.docid: 139573
negative_passages.text: Results from LINQ with SUM for TimeSpan, GROUP and JOIN
negative_passages.docid: 135100
negative_passages.text: How can you handle an IN sub-query with LINQ to SQL?
negative_passages.docid: 124247
negative_passages.text: C# code confusion of where clause
negative_passages.docid: 105953
negative_passages.text: When to use with clause in sql
negative_passages.docid: 23822
negative_passages.text: EF: Include with where clause
negative_passages.docid: 61502
negative_passages.text: SQL Coalesce in WHERE clause
negative_passages.docid: 21830
negative_passages.text: How to do joins in LINQ on multiple fields in single join
negative_passages.docid: 98335
negative_passages.text: How do I get the MAX row with a GROUP BY in LINQ query?
negative_passages.docid: 103080
negative_passages.text: slow query with fulltext and left join