LINQ Join Operators (Inner Join Left Join, Group Join, Cross Join)

In LINQ, joining operators join two or more lists/collections and get matched data from the collections based on specified expressions. The LINQ join operators behavior, and functionality will be same as SQL joins. 

 

In LINQ, we have different types of joins available those are

 

  • INNER JOIN
  • LEFT OUTER JOIN
  • CROSS JOIN
  • GROUP JOIN

We can get elements from both collections based on specified expressions using these joins. Following table show more detailed information related to joins in LINQ.

 

OperatorDescription
Inner Join It returns elements from the collections which satisfy specified expressions.
Left Outer Join It returns all the elements from the left side collection and matching elements from the right side collection
Cross Join It returns cartesian product of elements in collections
Group Join A join clause with an into an expression is called a group join

In the following chapters, we will learn all these linq joins in a detailed manner with examples.