title: Nested Where on 1-to-many in LINQ2Entity
body: <p>I'm using EF4. Having 2 entities:
  Person { Name }
  Hobbys { Person.Name, IsCoolHobby }
  1 Person can have several hobbys.</p>
  
  <p>I now have</p>
  
  <pre><code>IQueryable&lt;Person&gt; p;
  p = container.PersonSet.Include("Hobbys").AsQueryable();
  p = p.Where(x =&gt; x ?????);
  List&lt;Person&gt; tmp = p.ToList();
  </code></pre>
  
  <p>How can i return only those Persons who have cool hobbys (IsCoolHobby == true)? I tried join but i was not able to load them into the list (select can only return Person, Hobby or new Type - but how to map them to entity objects again?)</p>
  
  <p>Thanks</p>