Hi,

I am trying to join a parent table (to add a property) into my entity using the <join>. I understand <join> works the other way around but to join it using the entity's FK is using the property-ref attribute for the <key>. Applying property-ref seems to be useless to the SQL generated. Does anyone know what is wrong or is there a bug in nhibernate that I am not aware of (in regard to using <key> under <join>)

I tried NHibernate 2.0 and the latest NHibernate 2.1.0Alpha2
I am using NHibernate.Mapping.Attribute

The SQL generated is :
SELECT this_.ID as ID7_0_,
...,
this_1_.POLICY_NAME as POLICY2_8_0_ FROM BPAS_Base_mod.dbo.CS_USER_INFO this_ left outer join BPAS_Base_mod.dbo.CS_ACCOUNT_POLICY this_1_ on this_.ID=this_1_.ID WHERE this_.USER_NAME = @p0; @p0 = 'super'

The bold section in the SQL should have been POLICY_ID because I used property-ref in my <key>.

The schema is as such (NOTE: I am using NHibernate.Mapping.Attribute and this is just a generated schema):

<?xml version="1.0" encoding="utf-8"?>
<!--Generated by NHibernate.Mapping.Attributes on 2009-05-07 11:59:50Z.-->
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Consolsys.Domain.Impl.CsUserInfo, Consolsys.Domain" lazy="true" table="CS_USER_INFO">
<id name="Id" column="ID" type="long" unsaved-value="0">
<generator class="identity" />
</id>
....
<property name="PolicyId" column="POLICY_ID" not-null="true" />
<join table="CS_ACCOUNT_POLICY" optional="true">
<key column="ID" property-ref="PolicyId" on-delete="noaction" update="false" />
<property name="PolicyName" column="POLICY_NAME" />
</join>
</class>
</hibernate-mapping>

Apparently this is still an open case in nhibernate that needs to be resolve.

http://nhjira.koah.net/browse/NH-1452

I do hope they fix it coz I believe it is kinda important for some cases..