title: NHibernate - Equivalent of CountDistinct projection using LINQ
body: <p>I'm in the midst of trying to replace a the Criteria queries I'm using for a multi-field search page with LINQ queries using the new LINQ provider.  However, I'm running into a problem getting record counts so that I can implement paging.  I'm trying to achieve a result 
  equivalent to that produced by a CountDistinct projection from the Criteria API using LINQ.  Is there a way to do this?  </p>
  
  <p>The Distinct() method provided by LINQ doesn't seem to behave the way I would expect, and appending ".Distinct().Count()" to the end of a LINQ query grouped by the field I want a distinct count of (an integer ID column) seems to return a non-distinct count of those values.</p>
  
  <p>I can provide the code I'm using if needed, but since there are so many fields, it's 
  pretty long, so I didn't want to crowd the post if it wasn't needed. </p>
  
  <p>Thanks!</p>