Hi. outer-join option put into the class-level mapping. outerjoin true for
many-to-one, I'm doing. CreateQuery process moves down queries. However, the
sentences are written with linq queries coming down as innerjoin. There are
examples below.Unwillingness to proceed with Linq, but I can not keep any
inconvenience. Urgent, please help.
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="SalesManagement.Entity"
namespace="SalesManagement.Entity.Cari" >
<class name="Personel" table="Personel" entity-name="Personel" lazy="true"
schema="dbo">
<id name="Id" column="Id" type="Int64" unsaved-value="0">
<generator class="identity" />
</id>
<many-to-one name="BagliDepartman" column="BagliDepartman"
cascade="none" entity-name="Departman" lazy="proxy" outer-join="true" />
<property name="Adi" column="Adi" length="100" lazy="true" />
<property name="Soyadi" column="Soyadi" length="100" lazy="true" />
...
*linq query*
var xxx= _servicePersonel.GetAll().Select(q=>new
Models.Cari.Personel.PersonelListe
{
Id = q.Id,
Adi = q.Adi,
Soyadi = q.Soyadi,
BagliDepartman_Bilgisi =
q.BagliDepartman_Bilgisi
}).Take(5).ToList();
*
*
*
*
*linq result:*
select TOP ( 5 /* @p0 */ ) personel0_.Id as col_0_0_,
personel0_.Adi as col_1_0_,
personel0_.Soyadi as col_2_0_,
personel0_.BagliDepartman as col_3_0_,
departman2_.Adi as col_4_0_,
departman1_.Id as Id5_,
departman1_.BagliSirket as BagliSir2_5_
from dbo.Personel personel0_
* inner join dbo.Departman departman1_*
on personel0_.BagliDepartman = departman1_.Id,
dbo.Departman departman2_
where personel0_.BagliDepartman = departman2_.Id
Thanks, Tuncer
--
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.
