How to specify a lazy-loaded collection should be sorted in NHibernate?

Question

Is there a way to specify an order-by clause in my config XML to instruct nHibernate to lazy-load a collection property sorted by a particular property of the collection members?

Answer 1

Use the order-by attribute in the collection mapping. The syntax is

order-by="column_name asc|desc" 

Note that you specify the column name and not the property name.