title: Entity Framework 6 - Select Parents Where Children Equal
body: <p>I just need Parent objects. In SQL, this is simple:</p>
  
  <pre><code>select distinct * from parent 
  join child on child.ParentID = Parent.ID 
  where child.playssoccer = true;
  </code></pre>
  
  <p>In Entity Framework 6, this seems like splitting the atom to me.</p>
  
  <p>I need new p => parent where parents.children.playssoccer = true .</p>
  
  <p>How do I get soccer parents out of a similar EF6 DBContext?</p>