title: Querying Child Collections in LINQ
body: <p>I have a collection of objects called <code>Gigs</code>.</p>
  
  <p>Each <code>Gig</code> has an <code>Acts</code> collection.</p>
  
  <p>Using Linq I want to query my collection of gigs to get all gigs where with an act that has an id of 7 for example.</p>
  
  <pre><code>act.id = 7;
  </code></pre>
  
  <p>So I started writting...</p>
  
  <pre><code>return from gig in qry
         where gig.Acts //not sure how to do this bit
         select gig;
  </code></pre>
  
  <p>But I'm not sure how you set conditions on the child collection called acts.</p>
  
  <p>Any ideas?</p>