Related Post: Left Join With Where Clause In Linq C# Left Outer Join With Where Clause In Linq C# Left Join Using Where Clause Left Join Where Clause