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
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.
|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 expression is called a group join|
In the following chapters, we will learn all these linq joins in a detailed manner with examples.