I have a table that links to a second table by a <one-to-many> collection. My second table contains a property named Title.
My first table looks something like this :
Code:
<class name="Table1" table="...">
<id name="ProgramID" column="id_Program">
<generator class="assigned" />
</id>
<set name="ExtendedInfo">
<key column="id_program"/>
<one-to-many class="Table2"/>
</set>
</class>
My second table looks something like this :
Code:
<class name="Table2" table="...">
<composite-id >
<key-property name="ProgramID" column="id_Program"/>
<key-property name="Language" column="Language"/>
</composite-id>
<property name="OfficialTitle" column="OfficialTitle"/>
</class>
When I do my select, I'd like to be able to sort by OfficialTitle. That would look something like this :
Code:
IList myList =
myNHibernateSession.CreateCriteria(typeof(Table1)).
AddOrder(Expression.Order.Asc"ExtendedInfo.OfficialTitle").
List();
The problem is I can't access that Table2 property.
Anyone knows how I could do this?
Thank you
Olivier Dupuis