Hello,

I have a m:n mapping and do not know how to order the results.

Here is the mapping for class Category:


Now, ordering on "Name" does not work, of course, because that's a column in the "Product" table and not on the association table "ProductCategory". How can I reach the right table from the mapping?

Thanks,
Jan

Why not order in your code?

Like you probably now have an unordered NHibernate list in your Category class:

IList<Product> ProductList...

why not present a:

IList<Product> ProductsByName
{
return ProductList.Sort(new CompareProductrByName(...)
}