What is the CreateCriteria equiv of this line of code:

Question

_session.CreateQuery("Select a.AuLname From Authors a Order By a.AuLname") .List();

I must be drawing a blank here...but I cannot figure out how to return a list of author last names using the session's CreateCriteria method. Getting a distinct list of last names is not a problem as I can use a projection. But that is not what I am trying to do here.

TIA...

JP

Answer 1

Try this:

_session.CreateCriteria<Author>()
   .SetProjection(Projections.Property("AuLname"))
   .AddOrder(Order.Asc("AuLname"))
   .List();