title: NHibernate. Order by function result
body: <p>I need NHibernate to perform such query:  </p>
  
  <pre><code>SELECT * 
  FROM Users
  ORDER BY Func(FirstName, LastName)
  </code></pre>
  
  <p>Standart NHibernate <code>Order</code> class doesn't allow to do this. Is there any another way?<br>
  The fact is, named queries and HQL don't fit as a solution.  </p>
  
  <p><strong>EDIT:</strong> I found, that it is possible to do on SQL:  </p>
  
  <pre><code>SELECT *, Func(FirstName, LastName) AS FullName 
  FROM Users
  ORDER BY FullName
  </code></pre>
  
  <p>So, maybe it is possible to add extra field to criteria (or may be projection), like in this example?</p>