title: How to select parent and only one child, based on a property?
body: <p>In Fluent NHibernate, I have a class A, with an IList of children B.</p>
  
  <p>I want to select all A's which have a child B with a certain property B=="foo"</p>
  
  <p>I do not want to get back any other children of A.</p>
  
  <p>What is the Query expression to get this?</p>
  
  <pre><code>var list = session.Query&lt;A&gt;()
    .FetchMany(a=&gt;a.B)
    .Where( a=&gt;childBs.Any(b=&gt;b=="foo"));
  </code></pre>
  
  <p>But that returns all of the child Bs, not just the "foo" one.</p>