title: Nhibernate sort by datetime
body: <p>I'm trying to sort by datetime2(7) using CreateCriteria:</p>
  
  <pre><code>        var projection = Projections.Property("date"); 
          return session
              .CreateCriteria&lt;KnihovnaNovinky&gt;()
              .Add(Restrictions.Like("Type", type)) 
              .SetProjection(projection)
              .AddOrder(Order.Desc("Date"))
              .List&lt;KnihovnaNovinky&gt;();
  </code></pre>
  
  <p>Yet returned order is wrong. Could anyone help me? I'd like to keep criteria approach. Tried both Order.Asc / Desc, no effect.</p>