title: Convert this SQL to lambda for EF 4 Code first
body: <p>I have this Sql statement</p>
  
  <pre><code>SELECT * FROM Game 
          INNER JOIN Series ON Series.Id = Game.SeriesId 
          INNER JOIN SeriesTeams ON SeriesTeams.SeriesId = Series.Id 
          INNER JOIN Team ON Team.Id = SeriesTeams.TeamId 
          INNER JOIN TeamPlayers ON TeamPlayers.TeamId = Team.Id 
          INNER JOIN Player ON Player.Id = TeamPlayers.PlayerId 
      WHERE AND Game.StartTime &gt;= GETDATE() 
          AND Player.Id = 1
  </code></pre>
  
  <p>That I want to be converted into a lambda expression.</p>
  
  <p>This is how it works.</p>
  
  <p>A game can only be joined to 1 series, but a serie can of course have many games. A serie can have many teams and a team can join many series.
  A player can play in many teams and a team has many players.</p>
  
  <p>SeriesTeams and TeamPlayers are only the many-to-many tables created by EF to hold the references between series/teams and Teams/Players</p>
  
  <p>Thanks in advance...</p>
  
  <p>Edit: I use the EF 4 CTP5 and would like to have the answer as lambda functions, or in linq if that is easier...</p>