Mixing inheritance mapping strategies in NHibernate
- by MylesRip
I have a rather large inheritance hierarchy in which some of the subclasses add very little and others add quite a bit. I don't want to map the entire hierarchy using either "table per class hierarchy" or "table per subclass" due to the size and complexity of the hierarchy. Ideally I'd like to mix mapping strategies such that portions of the hierarchy where the subclasses add very little are combined into a common table a la "table per class hierarchy" and subclasses that add a lot are broken out into a separate table. Using this approach, I would expect to have 2 or 3 tables with very little wasted space instead of either 1 table with lots of fields that don't apply to most of the objects, or 20+ tables, several of which would have only a couple of columns.
In the NHibernate Reference Documentation version 2.1.0, I found section 8.1.4 "Mixing table per class hierarchy with table per subclass". This approach switches strategies partway down the hierarchy by using:
...
<subclass ...>
<join ...>
<property ...>
...
</join>
</subclass>
...
This is great in theory. In practice, though, I found that the schema was too restrictive in what was allowed inside the "join" element for me to be able to accomplish what I needed.
Here is the related part of the schema definition:
<xs:element name="join">
<xs:complexType>
<xs:sequence>
<xs:element ref="subselect" minOccurs="0" />
<xs:element ref="comment" minOccurs="0" />
<xs:element ref="key" />
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element ref="property" />
<xs:element ref="many-to-one" />
<xs:element ref="component" />
<xs:element ref="dynamic-component" />
<xs:element ref="any" />
<xs:element ref="map" />
<xs:element ref="set" />
<xs:element ref="list" />
<xs:element ref="bag" />
<xs:element ref="idbag" />
<xs:element ref="array" />
<xs:element ref="primitive-array" />
</xs:choice>
<xs:element ref="sql-insert" minOccurs="0" />
<xs:element ref="sql-update" minOccurs="0" />
<xs:element ref="sql-delete" minOccurs="0" />
</xs:sequence>
<xs:attribute name="table" use="required" type="xs:string" />
<xs:attribute name="schema" type="xs:string" />
<xs:attribute name="catalog" type="xs:string" />
<xs:attribute name="subselect" type="xs:string" />
<xs:attribute name="fetch" default="join">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="join" />
<xs:enumeration value="select" />
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="inverse" default="false" type="xs:boolean">
</xs:attribute>
<xs:attribute name="optional" default="false" type="xs:boolean">
</xs:attribute>
</xs:complexType>
</xs:element>
As you can see, this allows the use of "property" child elements or "component" child elements, but not both. It also doesn't allow for "subclass" child elements to continue the hierarchy below the point at which the strategy was changed.
Is there a way to accomplish this?
