Question

How to achieve Left Excluding JOIN using LINQ? In SQL: SELECT FROM Table_A A LEFT JOIN Table_B B ON A.Key = B.Key WHERE B.Key IS NULL JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You need DefaultIfEmpty() for the LEFT JOIN, then you can check if the joined value is null: var result = from a in Table_A join b in Table_B on a.Key equals b.Key into j from b in j.DefaultIfEmpty() where b == null select new { ... };