title: Entity Framework - Linq NOT IN query
body: <p>I've seen several other posts asking similar question but frankly I'm confused. 
  I'm trying to do the following sql statement in EntityFarmework and Linq but cant get the 'NOT IN' and 'UNION' working</p>
  
  <pre><code>SELECT LmsTeam.* FROM LmsTeam
  INNER JOIN Game ON LmsTeam.GameId = Game.ID 
  WHERE LmsTeam.Id NOT IN 
  (SELECT TeamHomeId as TeamID FROM LmsEventMatch WHERE EventId =1
  UNION
  SELECT TeamAwayId as TeamID FROM LmsEventMatch WHERE EventId =1)
  AND LmsTeam.GameId = 1 AND LmsTeam.Active = 1
  </code></pre>
  
  <p>So I've got the <code>join</code> and some of the where clause as below but can't do the <code>NOT IN</code> and <code>UNION</code> clauses.</p>
  
  <pre><code>from t in LmsTeams
  join g in Games on t.GameId equals g.Id
    where t.GameId == 1 &amp;&amp; t.Active == true
    select t
  </code></pre>