I have a "Task" type which has a property "Status" ("Status" type) that is a many-to-one association. I cannot for the life of me figure out how to sort Tasks using any properties on the Status class.

Using the following code throws this exception "could not resolve property:Status.Name of :Task"

ICriteria criteria = session.CreateCriteria( typeof( Task ) );
criteria.CreateCriteria( "Status", "Status" );
IList list = criteria.AddOrder( Order.Asc( "Status.Name" ) ).List( );

Would love any ideas or advice (besides coding the same query in HQL). Please let me know if I am doing something incorrectly.

This would be the corresponding T-SQL statement for what I am trying to accomplish...

SELECT * FROM task LEFT OUTER JOIN status ON task.status = status.id ORDER BY status.name

Is this possible in NHibernate?

I don't think there's a way to do what you want using criteria queries. Use HQL.

Sergey,

Thanks for the prompt response. I will try this using HQL.

If it makes sense to the project team, I would say that this functionalty would be a *very nce* addition to NHibernate.

However, I am in software development myself, and understand that sometimes the wants/needs of one customer may not match the direction of the greater customer base.

Anyways, keep up the great work!