c# - chaining a table of object with Linq -

i have 2 tables

players table (object) ------------- playerid name birthday list<matches> matches

and

matches table -------------- matchid playerid teamid

how can list of players , every row of player object contains list of matches has played ?

sincerly

you seek normal bring together in linq:

from p in players bring together m in matches on p.playerid equals m.playerid select new { p, m }

c# linq

JC