Hi Ive got a subclass, and I use this subclass on a bag, however I want to use the order by from the base class. But when I put the order by Nhibernate use the subclass. Does anyone know how to do this Ive put the mappings below.
If I run that the sql does ordeby PersonDocument.Name, but it should be Document.Name
Thanks...
<bag name="Documents" cascade="all" order-by="Name" >
<key column="PersonId"/>
<one-to-many class="PersonDocument" />
</bag>
<?xml version="1.0" encoding="utf-8" ?>
<many-to-one name="Type" class="DocumentType" column="DocumentTypeId" not-null="false" cascade="all" />
<joined-subclass table="PersonDocument" name="PersonDocument">
<key column="DocumentId"/>
<many-to-one name="EventGroupType" class="EventGroupType" column="EventGroupTypeId" not-null="false" cascade="all" />
</joined-subclass>
</class>