Hil All:

I am using:

NHibernate version: 1.0.1
MS SqlServer 2000

I am trying to create a query using CreateQuery method. And in that I want order the query objects to two level depth. For example:

IList records = session.CreateCriteria(typeof(Procurement))
.AddOrder(entityOrder)
.List();

and "entityOrder" defined as below:
Order entityOrder = Order.Desc("Department.DptEntity");

Please note that "Department" object represents a column in the "Procurement" table and "DptEntity" represents a column in the "Department" table.

This query generates exception saying "Use the NEW keyword to create an object". Through the debugger I checked that all my values are good including "entityOrder" (at least it does not generate exception on that statement (for "entityOrder" assignment).

Can anybody give me a clue? If two multi-depth is not allowed (as in ("Department.DptEntity"), how can I change it to reach my objective? I will appreciate the help.

Thank you.

As far as I know in a M-to-M it is only possible to "order-by" columns in the intermediate table. You'd have to "sort" on the java side with a comparator to achieve an ordered list from otherEntity.col.