Hibernate version:

NHibernate 1.2.0

Mapping documents:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="App.Core" namespace="App.Core.Domain">
<class name="Teacher" table="Teacher">
<id name="Id" column="TeacherId">
<generator class="identity" />
</id>
...
<bag name="Subjects" access="nosetter.camelcase-underscore" table="TeacherSubject" cascade="all">
<key column="TeacherId" />
<many-to-many class="Subject" column="SubjectId"/>
</bag>
</class>
</hibernate-mapping>


I have a many-to-many association: Teacher <--> Subject. A teacher can give multiple subjects; A subject can be given by multiple teachers.

How can I sort the Subjects collection of the Teacher class by the name of the subject? I already tried the 'order-by' element in the bag node. This doesn't work because this order applies to the TeacherSubject table and not to the Subject table.

Thanx in advance,
Jack

This is limitation of NHibernate and is not supported even by Hibernate. Quite common request on forum, hoverer i didn't found any explanation why this is not implemented...
Write comparator for your Subject class and use sort attribute on the collection.
Look here and here for more details...

Liwoj