Hi
We are currently using Nhibernate in a test environment. As newbies
we are having some newbie issues.
We were able to disable lazy loading on a class and even enable eager
loading on a set. This all works nice, we checked the sql statements,
but those statements are a bit weird.
The statement fetches the primary and foreign key properties for the
details multiple times. Since this doesn't add much to anything, this
cannot be by design and therefor I can assume we are doing something
wrong.
What are we doing wrong, causing NHibernate to generate jibberisch
SQL?
Please shed a light on my issues.
Thanks
Alexander
--SQL generated--
SELECT capitalize0_.ID as ID0_1_,
capitalize0_.PersistenceVersion as Persiste2_0_1_,
capitalize0_.RetirementCapital as Retireme3_0_1_,
m_capitali1_.CapitalizedAccountId as Capitali6_3_,
m_capitali1_.ID as ID3_,
m_capitali1_.ID as ID1_0_,
m_capitali1_.PersistenceVersion as Persiste2_1_0_,
m_capitali1_.CapitalizedAmount as Capitali3_1_0_,
m_capitali1_.StartDate as StartDate1_0_,
m_capitali1_.EndDate as EndDate1_0_,
m_capitali1_.CapitalizedAccountID as Capitali6_1_0_
FROM dbo.CapitalizedAccount capitalize0_
left outer join dbo.CapitalizedAccountSlice m_capitali1_ on
capitalize0_.ID = m_capitali1_.CapitalizedAccountId
WHERE capitalize0_.ID = @p0
-- bbm file --
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping
xmlns="urn:nhibernate-mapping-2.2"
assembly="PensioB.Payments"
namespace="PensioB.Payments.Semantics_I.Domain"
schema="dbo"
default-cascade="none"
default-access="field">
<!--dynamic updat required for optimistic locking strategy-->
<class
name="CapitalizedAccount"
table="CapitalizedAccount"
mutable="true"
lazy="false"
dynamic-insert="false"
select-before-update="false"
dynamic-update="true"
optimistic-lock="version">
<id
name="m_PersistenceId"
column="ID"
unsaved-value="null" >
<generator class="identity" />
</id>
<version
name="m_PersistenceVersion"
column="PersistenceVersion"
unsaved-value="null"
generated="never" />
<property
name="m_RetirementCapital"
column="RetirementCapital"
not-null="false"
length="50" />
<set name="m_CapitalizedAccountSlices" cascade="all"
inverse="true" lazy="false" outer-join="true">
<key column="CapitalizedAccountId" />
<one-to-many class="CapitalizedAccountSlice" />
</set>
<set name="m_CapitalizedAccountParts" cascade="none"
inverse="true" >
<key column="CapitalizedAccountId" />
<one-to-many class="CapitalizedAccountPart" />
</set>
</class>
</hibernate-mapping>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
