Problem with eager load polymorphic associations using Linq and NHibernate
Posted
by Voislav
on Stack Overflow
See other posts from Stack Overflow
or by Voislav
Published on 2010-04-13T19:19:37Z
Indexed on
2010/04/13
19:23 UTC
Read the original article
Hit count: 487
Is it possible to eagerly load polymorphic association using Linq and NH?
For example: Company is base class, Department is inherited from Company, and Company has association Employees to the User (one-to-many) and also association to the Country (many-to-one). Here is mapping part related to inherited class (without User and Country classes):
<class name="Company" discriminator-value="Company">
<id name="Id" type="int" unsaved-value="0" access="nosetter.camelcase-underscore">
<generator class="native"></generator>
</id>
<discriminator column="OrganizationUnit" type="string" length="10" not-null="true"/>
<property name="Name" type="string" length="50" not-null="true"/>
<many-to-one name="Country" class="Country" column="CountryId" not-null ="false" foreign-key="FK_Company_CountryId" access="field.camelcase-underscore" />
<set name="Departments" inverse="true" lazy="true" access="field.camelcase-underscore">
<key column="DepartmentParentId" not-null="false" foreign-key="FK_Department_DepartmentParentId"></key>
<one-to-many class="Department"></one-to-many>
</set>
<set name="Employees" inverse="true" lazy="true" access="field.camelcase-underscore">
<key column="CompanyId" not-null="false" foreign-key="FK_User_CompanyId"></key>
<one-to-many class="User"></one-to-many>
</set>
<subclass name="Department" extends="Company" discriminator-value="Department">
<many-to-one name="DepartmentParent" class="Company" column="DepartmentParentId" not-null ="false" foreign-key="FK_Department_DepartmentParentId" access="field.camelcase-underscore" />
</subclass>
</class>
I do not have problem to eagerly load any of the association on the Company:
Session.Query<Company>().Where(c => c.Name == "Main Company").Fetch(c => c.Country).Single();
Session.Query<Company>().Where(c => c.Name == "Main Company").FetchMany(c => c.Employees).Single();
Also, I could eagerly load not-polymorphic association on the department:
Session.Query<Department>().Where(d => d.Name == "Department 1").Fetch(d => d.DepartmentParent).Single();
But I get NullReferenceException when I try to eagerly load any of the polymorphic association (from the Department):
Assert.Throws<NullReferenceException>(() => Session.Query<Department>().Where(d => d.Name == "Department 1").Fetch(d => d.Country).Single());
Assert.Throws<NullReferenceException>(() => Session.Query<Department>().Where(d => d.Name == "Department 1").FetchMany(d => d.Employees).Single());
Am I doing something wrong or this is not supported yet?
© Stack Overflow or respective owner