CODEWITHSUNDEEP
nhibernate
bharat
bharat

Reputation: 11

NHibernate Left Join - in the join condition

<property name="MId" column="M_Id" update="false" insert="false" />

<many-to-one name="MGH" class="MGH" lazy="false">
  <column name="M_Id" />
</many-to-one>

<join table="SXX2">
  <key column="Study_Key" />
  <property name="GG" column="GG"/>
</join>

I want to join the SXX2 table with left join

Upvotes: 1

Views: 242

Answers (1)

Sam
Sam

Reputation: 4742

You're after the 'optional' attribute, ie:

<join table="SXX2" optional="true">
  <key column="Study_Key" />
  <property name="GG" column="GG"/>
</join>

Upvotes: 2

Related Questions