Part 18 : What is GROUP JOIN and Why use Group join?
When a join clause use an INTO expression, then it is called a group join. A group join produces a sequence of object arrays based on properties equivalence of left collection and right collection. If right collection has no matching elements with left collection then an empty array will be produced.
Basically, GROUP JOIN is like as INNER-EQUIJOIN except that the result sequence is organized into groups.
#sqlqueryinterviewquestionsandanswers #linqoperators #linqinterviewquestion