I have a mapping that defines two lists as properties, each made up of composite-elements. In the DB this is implemented by having a join to another table where each row in the joined table is an instance of the composite element.
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="OzoneHR.Domain"
namespace="OzoneHR.Domain.Questionnaires">
<class name="QuestionTemplate" table="QuestionTemplate">
<id name="Id" access="nosetter.camelcase-underscore"
column="QuestionTemplateID" type="Int32">
<generator class="identity" />
</id>
<property name="QuestionText" column="QuestionText" type="String" not-null="true" access="nosetter.camelcase-underscore" />
<bag name="SubDomains"
table="QuestionTemplateInSubdomain"
cascade="all"
access="nosetter.camelcase-underscore"
>
<key column="QuestionTemplateID" />
<composite-element class="QuestionnaireSubdomain">
<property name="SubdomainName" access="nosetter.camelcase-underscore" column="Subdomain" not-null="true" />
</composite-element>
</bag>
<bag name="Domains"
table="QuestionTemplateInDomain"
cascade="all"
access="nosetter.camelcase-underscore"
>
<key column="QuestionTemplateID" />
<composite-element class="QuestionnaireDomain">
<property name="DomainName" access="nosetter.camelcase-underscore" column="Domain" not-null="true" />
</composite-element>
</bag>
</class>
</hibernate-mapping>
What I'd like to do is a get a list of all the distinct Domains in the system. As domain isn't an entity, I only have access to it through the QuestionTemplate entity, my query I'm assuming will somehow have to go through the QuestionTemplate class, but I haven't been able to get it to work.
Login
FAQ
Search