title: Translate LINQ to SQL query to NHibernate (child collection filter)
body: <p>What is the correct translation of this LINQ to SQL query in NHibernate using the Criteria API?</p>
  
  <pre><code>var result = from e in Employees
      where e.WorkTimeEntries.Any(t =&gt; t.DateTime &gt;= new DateTime(2012, 3, 1))
      select e;
  </code></pre>
  
  <p>I have tried:</p>
  
  <pre><code>var employees       = Session.QueryOver&lt;Employee&gt;();
  var timeWorkedAlias = new HashedSet&lt;WorkTimeEntry&gt;();
  var timeWorked      = employees.Left.JoinQueryOver(e =&gt; e.WorkTimes,
                                                          () =&gt; timeWorkedAlias);
  timeWorkedAlias.Where (wa =&gt; wa.DateTime &gt;= new DateTime(2012,3,1));
  // How do to include the timeWorkedAlias 'filter' in the  query?
  
  var result = employees.List();
  </code></pre>
  
  <p>I am missing a couple of steps to include the date filter to be included in the query.</p>