title: Linq include with where clause
body: <p>Hey so I've got the situation where I'm pulling a client back from the database and including all the case studies with it by way of an include</p>
  
  <pre><code>return (from c in db.Clients.Include("CaseStudies")
          where c.Id == clientId
          select c).First();
  </code></pre>
  
  <p>but what I want to do now is and a where clause on the included casestudies so that it only returns the case studies where deleted = false</p>
  
  <p>sort of like this</p>
  
  <pre><code>return (from c in db.Clients.Include("CaseStudies")
          where c.Id == clientId
          &amp;&amp; c.CaseStudy.Deleted == false
          select c).First();
  </code></pre>
  
  <p>But this doesn't work :( any ideas</p>