title: Compound "from" clause in Linq query in Entity Framework
body: <p>I've been working with Entity Framework for a few weeks now.  I have been working with Linq-Objects and Linq-SQL for years.  A lot of times, I like to write linq statements like this:</p>
  
  <pre><code>from student in db.Students
  from score in student.Scores
  where score &gt; 90
  select student;
  </code></pre>
  
  <p>With other forms of linq, this returns distinct students who have at least one score greater than 90.  However, in EF this query returns one student for every score greater than 90.</p>
  
  <p>Does anyone know if this behavior can be replicated in unit tests?  Is it possible this is a bug in EF?</p>