Join and GroupJoin operations in C Sharp (C#) - Step-by-Step Execution

Concept Flow - Join and GroupJoin operations

Start with two collections

↓

Choose keys to match

↓

Join: Match pairs where keys equal

↓

GroupJoin: Match and group all matches

↓

Produce result: pairs or groups

↓

End

Join matches elements from two collections by keys, producing pairs; GroupJoin matches and groups all related elements from the second collection for each element in the first.

Execution Sample

C Sharp (C#)

var people = new[] { new { Id = 1, Name = "Alice" }, new { Id = 2, Name = "Bob" } };
var pets = new[] { new { OwnerId = 1, PetName = "Fluffy" }, new { OwnerId = 1, PetName = "Spot" }, new { OwnerId = 2, PetName = "Rex" } };

var joinResult = people.Join(pets, p => p.Id, pet => pet.OwnerId, (p, pet) => ($"{p.Name}", $"{pet.PetName}"));

var groupJoinResult = people.GroupJoin(pets, p => p.Id, pet => pet.OwnerId, (p, petGroup) => (p.Name, Pets: petGroup.Select(pg => pg.PetName).ToList()));

This code joins people with their pets by matching Id and OwnerId, showing both Join (pairs) and GroupJoin (groups) results.

Execution Table

Step	Operation	People Element	Pets Element(s)	Result Produced
1	Start	None	None	No output yet
2	Join: Match Alice (Id=1) with pets OwnerId=1	Alice (Id=1)	Fluffy, Spot	Pairs: (Alice, Fluffy), (Alice, Spot)
3	Join: Match Bob (Id=2) with pets OwnerId=2	Bob (Id=2)	Rex	Pair: (Bob, Rex)
4	GroupJoin: For Alice (Id=1), group pets OwnerId=1	Alice (Id=1)	Fluffy, Spot	Group: (Alice, [Fluffy, Spot])
5	GroupJoin: For Bob (Id=2), group pets OwnerId=2	Bob (Id=2)	Rex	Group: (Bob, [Rex])
6	GroupJoin: End	None	None	All groups produced
7	End	None	None	Join and GroupJoin complete

💡 All people processed; Join pairs and GroupJoin groups produced for each person

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 4	After Step 5	Final
joinResult	empty	[(Alice, Fluffy), (Alice, Spot)]	[(Alice, Fluffy), (Alice, Spot), (Bob, Rex)]	same	same	[(Alice, Fluffy), (Alice, Spot), (Bob, Rex)]
groupJoinResult	empty	empty	empty	[(Alice, [Fluffy, Spot])]	[(Alice, [Fluffy, Spot]), (Bob, [Rex])]	[(Alice, [Fluffy, Spot]), (Bob, [Rex])]

Key Moments - 2 Insights

Why does Join produce multiple pairs for Alice but GroupJoin produces one group?

Join creates one pair for each matching pet (see Step 2), while GroupJoin collects all matching pets into a single group for Alice (see Step 4).

What happens if a person has no matching pets in GroupJoin?

GroupJoin still produces a result with an empty group for that person, unlike Join which would produce no pairs for that person.

Visual Quiz - 3 Questions

Look at the execution table, what pets are paired with Alice in the Join operation at Step 2?

A No pets

B Rex only

C Fluffy and Spot

D Fluffy only

💡 Hint

Check Step 2 in the execution_table where Alice matches pets with OwnerId=1

At which step does GroupJoin produce the group for Bob?

A Step 5

B Step 3

C Step 2

D Step 6

💡 Hint

Look at Step 5 in execution_table where Bob's group is created

If a new person with Id=3 has no pets, what would GroupJoin produce for them?

A No output for that person

B A group with empty pet list

C An error

D A pair with null pet

💡 Hint

Recall key moment 2 about GroupJoin behavior with no matches

Concept Snapshot

Join and GroupJoin in C# LINQ:
- Join matches elements from two collections by keys, producing pairs.
- GroupJoin matches elements and groups all related matches from second collection.
- Join outputs one pair per match; GroupJoin outputs one group per first collection element.
- GroupJoin includes elements with empty groups if no matches.
- Syntax: Join(inner, outerKey, innerKey, resultSelector), GroupJoin similarly but groups matches.

Full Transcript

This visual execution shows how Join and GroupJoin work in C#. We start with two collections: people and pets. Join matches each person with each pet that has the same key (Id and OwnerId), producing pairs. For example, Alice matches two pets, so Join produces two pairs for her. GroupJoin matches each person with all their pets grouped together, producing one group per person. Even if a person has no pets, GroupJoin produces an empty group for them. The execution table traces each step, showing which elements are matched and what results are produced. Variable tracking shows how the results build up over steps. Key moments clarify common confusions about multiple pairs vs groups and handling no matches. The quiz tests understanding by asking about specific steps and outcomes. This helps beginners see exactly how these LINQ operations work step-by-step.