Part 19 : What is Left Join and Cross join in Linq?
3. LEFT OUTER JOIN - LEFT JOIN returns all records or rows from left table and from right table returns only matched records. If there are no columns matching in the right table, it returns NULL values. In LINQ to achieve LEFT JOIN behavior, it is mandatory to use "INTO" keyword and "DefaultIfEmpty()" method
4. CROSS JOIN - Cross join is a Cartesian join means Cartesian product of both the tables. This join does not need any condition to join two tables. This join returns records or rows that are multiplication of record number from both the tables’ means each row on left table will relate to each row of right table.
#sqlqueryinterviewquestionsandanswers #linqinterviewquestion
https://sider.ai/AI-video-shortener-s...