I am reading rows from table Foo with a join fetch mode with child table Bar. Everything works and I can order by doing this:

crit.AddOrder(NHibernate.Expression.Order.Asc("FooName"));

But I want to order the rows by a column in child table Bar. I want to do this:

crit.AddOrder(NHibernate.Expression.Order.Asc("Bar.BarName"));

However, this doesn't work (exception "could not resolve property:Bar.BarName of :NhibPOC.Foo").

How can I order by a column in the child table? Thanks

you need a second criteria:

Thanks... In general, do I have to call List() on the 2nd criteria? Or can I call on either one? I'm just wondering, if I create a hierarchy of criteria, which one I would need to call List()

Thanks

hmmm, that's a good question. i've never tried to call list on anything but the top criteria because i always use method chaining. that sort of forces me to call list to end the chain... sorry i don't know the official answer for that.

-devon

Woops... I tried just tried your suggestion and (A) it did not compile and (B) when I got it to compile, I got the exception "subcriteria cannot be ordered". So it looks like your idea actually doesn't work. By the way, I had to change it to look like this:



There isn't any way to pass a type into the second CreateCriteria call. You have to pass the "AssociationPath", which apparently is the name of the parameter referencing through the join.

In any case, I got the exception about subcriteria cannot be ordered. So I'm back to square one.