What are we trying to achieve?
Suppose you want to join Employees Table and Players Table on first name.
How do we do it?
Suppose you want to join Employees Table and Players Table on first name.
Employees Table:
FirstName
|
Employer
|
A
|
TJX
|
B
|
G4s
|
C
|
Google
|
Players Table:
FirstName
|
Club
|
A
|
Manchester United
|
D
|
Chelsea
|
C
|
Arsenal
|
Table that joins the above two tables on first name.
FirstName
|
Employer
|
Club
|
A
|
TJX
|
Manchester United
|
C
|
Google
|
Arsenal
|
How do we do it?
The way you would
do this in C# is by creating two Lists and then combine them using join.
This is how the code that does the join looks like
Join:
var playerEmployee = from employee in empList
join player in soclist
on employee.FirstName equals player.FirstName
select new { employee, player };
foreach (var x in playerEmployee)
{
}
Left Join:
SoccerPlayer dummyPlayer = new SoccerPlayer();
var playerEmployeeLeftJoin = from employee in empList
join player in soclist
on employee.FirstName equals player.FirstName into playerAlias
from player in playerAlias.DefaultIfEmpty()
select new { employee, player = (player == null ? dummyPlayer : player) };
foreach (var x in playerEmployeeLeftJoin)
{
}
