Collection key referencing non-primary-key field

bambuk · **Joined:** Tue Jul 03, 2007 11:44 am **Posts:** 2

Is it possible to have a collection whose foreign key references a column which is not a primary key but just a unique column?

Code:

<class name="Index" table="index_names">
      <id name="Id" column="id">
          <generator class="assigned"/>
      </id>
      <property name="Name" column="name" length="36" unique-key="true"/>
      <bag name="Values" inverse="true" table="index_values" order-by="date asc">
        <key column="name"/>
        <composite-element class="IndexValue">
            <property name="Date" column="date"/>
            <property name="Value" column="value"/>
        </composite-element>
      </bag>
  </class>

Note <key column="name"/>.

Is this supported in NHibernate?
If no, is there a workaround?

bambuk · **Joined:** Tue Jul 03, 2007 11:44 am **Posts:** 2

Anybody?

IgorK · **Posted:** Thu Jul 05, 2007 11:22 am

Hi bambuk!

Maybe you can use some sort of NHibernate query to fill collection? i.e. remove bag from mapping and add code to collection property getter...