Here is where I am since my last reply. The way the db is structured I need to do a many-to-one to get the "name" part of the paired keys. This is returned at the first child node layer. What I want to do now is to add a <map tag that points to this instead of a table. For example,
<class name="Dave" table="ControlNumberField">
<id name="ControlNumberFieldID" type="System.Int32" column="ControlNumberFieldID" unsaved-value="0">
<generator class="identity"/>
</id>
<property name="ControlNumberMetaID" />
<property name="AttributeFieldID" />
<many-to-one name="AttributeFields" class="AttributeField" fetch="join" column="AttributeFieldID" cascade="all" />
<!--
****This is where I am stuck****
****This is where I am stuck****
Instead of having table="CustomAttributeValue" I want to have something like table="{result of the above join}"
-->
<map name="Attributes" table="CustomAttributeValue">
<key column="ControlNumberFieldID"/>
<index column="Name" type="System.String"/>
<element column="Value" type="System.String"/>
</map>
Login
FAQ
Search