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

  Total Views : 291
  Comments : 0
 
  Keywords : Linq join operators in c# / vb.net with examples, How to use joining operators in linq with examples, Different type of linq join operators (left outer join, group join, inner & cross join)

Here we will learn linq join operators in c#, vb.net with examples and different type of linq join operators (inner join, left outer join, cross join, group join) in c#, vb.net with examples.

LINQ Join Operators

In LINQ joining operators are used to 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 type of joins available those are

 

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

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

 

OperatorDescription
Inner Join It return elements from the collections which satisfies specified expressions
Left Outer Join It return all the elements from 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 as group join

In next chapters we will learn all these linq joins in detailed manner with examples.

 

NEXT

LINQ Inner Join  
 

 Comments (0)

Be the first to give your valuable feedback

Leave a comment

  • Default Tutlane User