CODEWITHSUNDEEP
c#.netsql-server-2008nhibernate
BennoDual
BennoDual

Reputation: 6259

NHibernate - create order

I am searching for a solution for creating an order by clause. I have a table which has a column for created and one for changed. These two columns contains a DateTime. Changed could be null, if a record was only created and never changed. Now I should select it with HQL all records ordered by changed desc, if changed is not null, else, if changed is null, by created desc.

Upvotes: 0

Views: 712

Answers (1)

evilone
evilone

Reputation: 22740

Example, how to create order by clause in NHibernate:

var result = Session.CreateCriteria(typeof(Users))
                    .AddOrder(Order.Desc("FirstName"))
                    .AddOrder(Order.Desc("LastName"))
                    .List<Users>();

Upvotes: 3

Related Questions