title: Nothing in query linq
body: <p>I'm trying to translate sql to linq but I get nothing in my query.
  My sql:</p>
  
  <pre><code>select e.FirstAired, s.SeriesName, e.EpisodeNr, e.SeasonNr
  from series s 
  join LaastGedownloads l on s.SeriesID = l.SeriesID
  join Episodes e on e.SeriesID = l.SeriesID
  where e.EpisodeNr = l.LastEpisode
  and e.SeasonNr = l.LastSeason
  </code></pre>
  
  <p>My Linq</p>
  
  <pre><code>SerieContext sc = new SerieContext();
  List&lt;Serie&gt; ds=sc.series.Include("Episodes").Include("LaastGedownload").ToList();
  var query = (from s in sc.series
               join l in sc.LaastGedownload on s.SeriesID equals l.SeriesID
               join e in sc.Episodes on l.SeriesID equals e.SeasonID
               where e.EpisodeNr == l.LastEpisode
                     &amp;&amp; e.SeasonNr == l.LastSeason
               select s).ToList();
  </code></pre>
  
  <p><a href="https://www.dropbox.com/s/0277lndbunr3fgs/TheNewSerieDatabase.zip" rel="nofollow">My VS2013 solution zip</a></p>