using fetch
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_Part_31_20162858.1337846096089"
------=_Part_31_20162858.1337846096089
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit
Because it's a Cartesian product the top N will limit the product not
the root - you could try doing the actual filter part of the query
(with the starts-with and row limit) as a subquery and fetch the phones
in the outer query saying "where user id in (subquery)"
Sent from my Windows Phone
From: Michael Logutov
Sent: 24/05/2012 12:50
To: [email protected]
Subject: [nhusers] NHibernate select top N with condition on children
using fetch
This is crosspost from SO:
http://stackoverflow.com/questions/10721633/nhibernate-select-top-n-with-condition-on-children-using-fetch/10724015
I have simple User entity:
public class User
{
public virtual int Id { get; set; }
public virtual DateTime CreationDate { get; set; }
public virtual DateTime ModifiedDate { get; set; }
public virtual string Email { get; set; }
public virtual string Name { get; set; }
public virtual IList<Phone> Phones { get; set; }
}
public class Phone
{
public virtual string CountryCode { get; set; }
public virtual string Code { get; set; }
public virtual string Number { get; set; }
public virtual string Comment { get; set; }
}
My mappings defined as this:
public class UserMap : ClassMap<User>
{
public UserMap ()
{
this.Table ("Users");
this.Id (x => x.Id).CustomSqlType ("bigint").GeneratedBy.HiLo ("1000");
this.Map (x => x.CreationDate);
this.Map (x => x.ModifiedDate).Column ("LastUpdatedDate");
this.Map (x => x.Email).Length (255).Not.Nullable ().Unique ();
this.Map (x => x.Name).Column ("UserName").Length (255);
this.HasMany (x => x.Phones).Inverse ();
}
}
public class PhoneMap : ClassMap<Phone>
{
public PhoneMap ()
{
this.Table ("Phones");
this.Id ().GeneratedBy.Identity ();
this.Map (x => x.CountryCode).Length (5);
this.Map (x => x.Code).Length (10);
this.Map (x => x.Number).Length (50).Not.Nullable ();
this.Map (x => x.Comment).Length (255);
}
}
Additional conventions here:
PrimaryKey.Name.Is (x => "Id"),
ForeignKey.EndsWith ("Id"),
DefaultAccess.Property (),
DefaultCascade.All ()
*I need to select top 100 users with Phones and whose name starts with "A".
But I need to load user objects with Phones in them.*
So I do this query:
var users =
(
from user in session.Query<User> ()
where
user.Name.StartsWith ("a")
&&
user.Phones.Any ()
select user
)
.Fetch (x => x.Phones)
.Take (100)
.ToArray ();
And I only got 72 users.
Why? Well, because NHibernate generates single TOP N select with left outer
join and SQL returns several records for the same user entity because some
users do have more that one phone. But it's all counts against TOP N - so I
get 100 records of users joined with phones, but only 72 of them are unique
entities.
Is there a proper way to do it?
--
You received this message because you are subscribed to the Google
Groups "nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/CRs12WZlWOAJ.
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.
------=_Part_31_20162858.1337846096089
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
<html><head><meta content=3D"text/html; charset=3Dutf-8" http-equiv=3D"Cont=
ent-Type"></head><body><div><div style=3D"font-family: Calibri,sans-serif; =
font-size: 11pt;">Because it's a Cartesian product the top N will limit the=
product not the root - you could try doing the actual filter part of the q=
uery (with the starts-with and row limit) as a subquery and fetch the phone=
s in the outer query saying "where user id in (subquery)"<br><br>Sent from =
my Windows Phone<br></div></div><hr><span style=3D"font-family: Tahoma,sans=
-serif; font-size: 10pt; font-weight: bold;">From: </span><span style=3D"fo=
nt-family: Tahoma,sans-serif; font-size: 10pt;">Michael Logutov</span><br><=
span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight:=
bold;">Sent: </span><span style=3D"font-family: Tahoma,sans-serif; font-si=
ze: 10pt;">24/05/2012 12:50</span><br><span style=3D"font-family: Tahoma,sa=
ns-serif; font-size: 10pt; font-weight: bold;">To: </span><span style=3D"fo=
nt-family: Tahoma,sans-serif; font-size: 10pt;">[email protected]</s=
pan><br><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt; fon=
t-weight: bold;">Subject: </span><span style=3D"font-family: Tahoma,sans-se=
rif; font-size: 10pt;">[nhusers] NHibernate select top N with condition on =
children using fetch</span><br><br></body></html><p style=3D"font-size: 14p=
x; clear: both; word-wrap: break-word; color: rgb(0, 0, 0); font-family: Ar=
ial, 'Liberation Sans', 'DejaVu Sans', sans-serif; text-align: left; ">This=
is crosspost from SO: <a href=3D"http://stackoverflow.com/questions/1=
0721633/nhibernate-select-top-n-with-condition-on-children-using-fetch/1072=
4015">http://stackoverflow.com/questions/10721633/nhibernate-select-top-n-w=
ith-condition-on-children-using-fetch/10724015</a></p><p style=3D"font-size=
: 14px; clear: both; word-wrap: break-word; color: rgb(0, 0, 0); font-famil=
y: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; text-align: left; "=
><br></p><p style=3D"font-size: 14px; clear: both; word-wrap: break-word; c=
olor: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', s=
ans-serif; text-align: left; ">I have simple User entity:<br></p><pre class=
=3D"lang-sql prettyprint" style=3D"margin-bottom: 10px; padding: 5px; font-=
size: 14px; background-color: rgb(238, 238, 238); font-family: Consolas, Me=
nlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bits=
tream Vera Sans Mono', 'Courier New', monospace, serif; overflow: auto; wid=
th: auto; max-height: 600px; color: rgb(0, 0, 0); line-height: 18px; text-a=
lign: left; "><code style=3D"font-family: Consolas, Menlo, Monaco, 'Lucida =
Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono'=
, 'Courier New', monospace, serif; "><span class=3D"kwd" style=3D"backgroun=
d-color: transparent; color: rgb(0, 0, 139); ">public</span><span class=3D"=
pln" style=3D"background-color: transparent; "> class </span><span class=3D=
"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139); ">User=
</span><span class=3D"pln" style=3D"background-color: transparent; "><br></=
span><span class=3D"pun" style=3D"background-color: transparent; ">{</span>=
<span class=3D"pln" style=3D"background-color: transparent; "><br> &n=
bsp; </span><span class=3D"kwd" style=3D"background-color: transparent; col=
or: rgb(0, 0, 139); ">public</span><span class=3D"pln" style=3D"background-=
color: transparent; "> virtual int Id </span><span class=3D"pun" style=3D"b=
ackground-color: transparent; ">{</span><span class=3D"pln" style=3D"backgr=
ound-color: transparent; "> get</span><span class=3D"pun" style=3D"backgrou=
nd-color: transparent; ">;</span><span class=3D"pln" style=3D"background-co=
lor: transparent; "> </span><span class=3D"kwd" style=3D"background-color: =
transparent; color: rgb(0, 0, 139); ">set</span><span class=3D"pun" style=
=3D"background-color: transparent; ">;</span><span class=3D"pln" style=3D"b=
ackground-color: transparent; "> </span><span class=3D"pun" style=3D"backgr=
ound-color: transparent; ">}</span><span class=3D"pln" style=3D"background-=
color: transparent; "><br> </span><span class=3D"kwd" style=3D=
"background-color: transparent; color: rgb(0, 0, 139); ">public</span><span=
class=3D"pln" style=3D"background-color: transparent; "> virtual DateTime =
CreationDate </span><span class=3D"pun" style=3D"background-color: transpar=
ent; ">{</span><span class=3D"pln" style=3D"background-color: transparent; =
"> get</span><span class=3D"pun" style=3D"background-color: transparent; ">=
;</span><span class=3D"pln" style=3D"background-color: transparent; "> </sp=
an><span class=3D"kwd" style=3D"background-color: transparent; color: rgb(0=
, 0, 139); ">set</span><span class=3D"pun" style=3D"background-color: trans=
parent; ">;</span><span class=3D"pln" style=3D"background-color: transparen=
t; "> </span><span class=3D"pun" style=3D"background-color: transparent; ">=
}</span><span class=3D"pln" style=3D"background-color: transparent; "><br>&=
nbsp; </span><span class=3D"kwd" style=3D"background-color: transpar=
ent; color: rgb(0, 0, 139); ">public</span><span class=3D"pln" style=3D"bac=
kground-color: transparent; "> virtual DateTime ModifiedDate </span><span c=
lass=3D"pun" style=3D"background-color: transparent; ">{</span><span class=
=3D"pln" style=3D"background-color: transparent; "> get</span><span class=
=3D"pun" style=3D"background-color: transparent; ">;</span><span class=3D"p=
ln" style=3D"background-color: transparent; "> </span><span class=3D"kwd" s=
tyle=3D"background-color: transparent; color: rgb(0, 0, 139); ">set</span><=
span class=3D"pun" style=3D"background-color: transparent; ">;</span><span =
class=3D"pln" style=3D"background-color: transparent; "> </span><span class=
=3D"pun" style=3D"background-color: transparent; ">}</span><span class=3D"p=
ln" style=3D"background-color: transparent; "><br><br> </span>=
<span class=3D"kwd" style=3D"background-color: transparent; color: rgb(0, 0=
, 139); ">public</span><span class=3D"pln" style=3D"background-color: trans=
parent; "> virtual string Email </span><span class=3D"pun" style=3D"backgro=
und-color: transparent; ">{</span><span class=3D"pln" style=3D"background-c=
olor: transparent; "> get</span><span class=3D"pun" style=3D"background-col=
or: transparent; ">;</span><span class=3D"pln" style=3D"background-color: t=
ransparent; "> </span><span class=3D"kwd" style=3D"background-color: transp=
arent; color: rgb(0, 0, 139); ">set</span><span class=3D"pun" style=3D"back=
ground-color: transparent; ">;</span><span class=3D"pln" style=3D"backgroun=
d-color: transparent; "> </span><span class=3D"pun" style=3D"background-col=
or: transparent; ">}</span><span class=3D"pln" style=3D"background-color: t=
ransparent; "><br> </span><span class=3D"kwd" style=3D"backgro=
und-color: transparent; color: rgb(0, 0, 139); ">public</span><span class=
=3D"pln" style=3D"background-color: transparent; "> virtual string Name </s=
pan><span class=3D"pun" style=3D"background-color: transparent; ">{</span><=
span class=3D"pln" style=3D"background-color: transparent; "> get</span><sp=
an class=3D"pun" style=3D"background-color: transparent; ">;</span><span cl=
ass=3D"pln" style=3D"background-color: transparent; "> </span><span class=
=3D"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139); ">s=
et</span><span class=3D"pun" style=3D"background-color: transparent; ">;</s=
pan><span class=3D"pln" style=3D"background-color: transparent; "> </span><=
span class=3D"pun" style=3D"background-color: transparent; ">}</span><span =
class=3D"pln" style=3D"background-color: transparent; "><br><br> &nbs=
p; </span><span class=3D"kwd" style=3D"background-color: transparent; color=
: rgb(0, 0, 139); ">public</span><span class=3D"pln" style=3D"background-co=
lor: transparent; "> virtual IList</span><span class=3D"pun" style=3D"backg=
round-color: transparent; "><</span><span class=3D"pln" style=3D"backgro=
und-color: transparent; ">Phone</span><span class=3D"pun" style=3D"backgrou=
nd-color: transparent; ">></span><span class=3D"pln" style=3D"background=
-color: transparent; "> Phones </span><span class=3D"pun" style=3D"backgrou=
nd-color: transparent; ">{</span><span class=3D"pln" style=3D"background-co=
lor: transparent; "> get</span><span class=3D"pun" style=3D"background-colo=
r: transparent; ">;</span><span class=3D"pln" style=3D"background-color: tr=
ansparent; "> </span><span class=3D"kwd" style=3D"background-color: transpa=
rent; color: rgb(0, 0, 139); ">set</span><span class=3D"pun" style=3D"backg=
round-color: transparent; ">;</span><span class=3D"pln" style=3D"background=
-color: transparent; "> </span><span class=3D"pun" style=3D"background-colo=
r: transparent; ">}</span><span class=3D"pln" style=3D"background-color: tr=
ansparent; "><br></span><span class=3D"pun" style=3D"background-color: tran=
sparent; ">}</span><span class=3D"pln" style=3D"background-color: transpare=
nt; "><br><br></span><span class=3D"kwd" style=3D"background-color: transpa=
rent; color: rgb(0, 0, 139); ">public</span><span class=3D"pln" style=3D"ba=
ckground-color: transparent; "> class Phone<br></span><span class=3D"pun" s=
tyle=3D"background-color: transparent; ">{</span><span class=3D"pln" style=
=3D"background-color: transparent; "><br> </span><span class=
=3D"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139); ">p=
ublic</span><span class=3D"pln" style=3D"background-color: transparent; "> =
virtual string CountryCode </span><span class=3D"pun" style=3D"background-c=
olor: transparent; ">{</span><span class=3D"pln" style=3D"background-color:=
transparent; "> get</span><span class=3D"pun" style=3D"background-color: t=
ransparent; ">;</span><span class=3D"pln" style=3D"background-color: transp=
arent; "> </span><span class=3D"kwd" style=3D"background-color: transparent=
; color: rgb(0, 0, 139); ">set</span><span class=3D"pun" style=3D"backgroun=
d-color: transparent; ">;</span><span class=3D"pln" style=3D"background-col=
or: transparent; "> </span><span class=3D"pun" style=3D"background-color: t=
ransparent; ">}</span><span class=3D"pln" style=3D"background-color: transp=
arent; "><br> </span><span class=3D"kwd" style=3D"background-c=
olor: transparent; color: rgb(0, 0, 139); ">public</span><span class=3D"pln=
" style=3D"background-color: transparent; "> virtual string Code </span><sp=
an class=3D"pun" style=3D"background-color: transparent; ">{</span><span cl=
ass=3D"pln" style=3D"background-color: transparent; "> get</span><span clas=
s=3D"pun" style=3D"background-color: transparent; ">;</span><span class=3D"=
pln" style=3D"background-color: transparent; "> </span><span class=3D"kwd" =
style=3D"background-color: transparent; color: rgb(0, 0, 139); ">set</span>=
<span class=3D"pun" style=3D"background-color: transparent; ">;</span><span=
class=3D"pln" style=3D"background-color: transparent; "> </span><span clas=
s=3D"pun" style=3D"background-color: transparent; ">}</span><span class=3D"=
pln" style=3D"background-color: transparent; "><br> </span><sp=
an class=3D"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 1=
39); ">public</span><span class=3D"pln" style=3D"background-color: transpar=
ent; "> virtual string Number </span><span class=3D"pun" style=3D"backgroun=
d-color: transparent; ">{</span><span class=3D"pln" style=3D"background-col=
or: transparent; "> get</span><span class=3D"pun" style=3D"background-color=
: transparent; ">;</span><span class=3D"pln" style=3D"background-color: tra=
nsparent; "> </span><span class=3D"kwd" style=3D"background-color: transpar=
ent; color: rgb(0, 0, 139); ">set</span><span class=3D"pun" style=3D"backgr=
ound-color: transparent; ">;</span><span class=3D"pln" style=3D"background-=
color: transparent; "> </span><span class=3D"pun" style=3D"background-color=
: transparent; ">}</span><span class=3D"pln" style=3D"background-color: tra=
nsparent; "><br> </span><span class=3D"kwd" style=3D"backgroun=
d-color: transparent; color: rgb(0, 0, 139); ">public</span><span class=3D"=
pln" style=3D"background-color: transparent; "> virtual string Comment </sp=
an><span class=3D"pun" style=3D"background-color: transparent; ">{</span><s=
pan class=3D"pln" style=3D"background-color: transparent; "> get</span><spa=
n class=3D"pun" style=3D"background-color: transparent; ">;</span><span cla=
ss=3D"pln" style=3D"background-color: transparent; "> </span><span class=3D=
"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139); ">set<=
/span><span class=3D"pun" style=3D"background-color: transparent; ">;</span=
><span class=3D"pln" style=3D"background-color: transparent; "> </span><spa=
n class=3D"pun" style=3D"background-color: transparent; ">}</span><span cla=
ss=3D"pln" style=3D"background-color: transparent; "><br></span><span class=
=3D"pun" style=3D"background-color: transparent; ">}</span><span class=3D"p=
ln" style=3D"background-color: transparent; "><br></span></code></pre><p st=
yle=3D"font-size: 14px; clear: both; word-wrap: break-word; color: rgb(0, 0=
, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; tex=
t-align: left; ">My mappings defined as this:</p><pre class=3D"lang-sql pre=
ttyprint" style=3D"margin-bottom: 10px; padding: 5px; font-size: 14px; back=
ground-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lu=
cida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans =
Mono', 'Courier New', monospace, serif; overflow: auto; width: auto; max-he=
ight: 600px; color: rgb(0, 0, 0); line-height: 18px; text-align: left; "><c=
ode style=3D"font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liber=
ation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New',=
monospace, serif; "><span class=3D"kwd" style=3D"background-color: transpa=
rent; color: rgb(0, 0, 139); ">public</span><span class=3D"pln" style=3D"ba=
ckground-color: transparent; "> class UserMap </span><span class=3D"pun" st=
yle=3D"background-color: transparent; ">:</span><span class=3D"pln" style=
=3D"background-color: transparent; "> ClassMap</span><span class=3D"pun" st=
yle=3D"background-color: transparent; "><</span><span class=3D"kwd" styl=
e=3D"background-color: transparent; color: rgb(0, 0, 139); ">User</span><sp=
an class=3D"pun" style=3D"background-color: transparent; ">></span><span=
class=3D"pln" style=3D"background-color: transparent; "><br></span><span c=
lass=3D"pun" style=3D"background-color: transparent; ">{</span><span class=
=3D"pln" style=3D"background-color: transparent; "><br> </span=
><span class=3D"kwd" style=3D"background-color: transparent; color: rgb(0, =
0, 139); ">public</span><span class=3D"pln" style=3D"background-color: tran=
sparent; "> UserMap </span><span class=3D"pun" style=3D"background-color: t=
ransparent; ">()</span><span class=3D"pln" style=3D"background-color: trans=
parent; "><br> </span><span class=3D"pun" style=3D"background-=
color: transparent; ">{</span><span class=3D"pln" style=3D"background-color=
: transparent; "><br> this</span><span class=3D"=
pun" style=3D"background-color: transparent; ">.</span><span class=3D"kwd" =
style=3D"background-color: transparent; color: rgb(0, 0, 139); ">Table</spa=
n><span class=3D"pln" style=3D"background-color: transparent; "> </span><sp=
an class=3D"pun" style=3D"background-color: transparent; ">(</span><span cl=
ass=3D"str" style=3D"background-color: transparent; color: rgb(128, 0, 0); =
">"Users"</span><span class=3D"pun" style=3D"background-color: transparent;=
">);</span><span class=3D"pln" style=3D"background-color: transparent; "><=
br><br> this</span><span class=3D"pun" style=3D"=
background-color: transparent; ">.</span><span class=3D"pln" style=3D"backg=
round-color: transparent; ">Id </span><span class=3D"pun" style=3D"backgrou=
nd-color: transparent; ">(</span><span class=3D"pln" style=3D"background-co=
lor: transparent; ">x </span><span class=3D"pun" style=3D"background-color:=
transparent; ">=3D></span><span class=3D"pln" style=3D"background-color=
: transparent; "> x</span><span class=3D"pun" style=3D"background-color: tr=
ansparent; ">.</span><span class=3D"pln" style=3D"background-color: transpa=
rent; ">Id</span><span class=3D"pun" style=3D"background-color: transparent=
; ">).</span><span class=3D"pln" style=3D"background-color: transparent; ">=
CustomSqlType </span><span class=3D"pun" style=3D"background-color: transpa=
rent; ">(</span><span class=3D"str" style=3D"background-color: transparent;=
color: rgb(128, 0, 0); ">"bigint"</span><span class=3D"pun" style=3D"backg=
round-color: transparent; ">).</span><span class=3D"pln" style=3D"backgroun=
d-color: transparent; ">GeneratedBy</span><span class=3D"pun" style=3D"back=
ground-color: transparent; ">.</span><span class=3D"pln" style=3D"backgroun=
d-color: transparent; ">HiLo </span><span class=3D"pun" style=3D"background=
-color: transparent; ">(</span><span class=3D"str" style=3D"background-colo=
r: transparent; color: rgb(128, 0, 0); ">"1000"</span><span class=3D"pun" s=
tyle=3D"background-color: transparent; ">);</span><span class=3D"pln" style=
=3D"background-color: transparent; "><br> this</=
span><span class=3D"pun" style=3D"background-color: transparent; ">.</span>=
<span class=3D"pln" style=3D"background-color: transparent; ">Map </span><s=
pan class=3D"pun" style=3D"background-color: transparent; ">(</span><span c=
lass=3D"pln" style=3D"background-color: transparent; ">x </span><span class=
=3D"pun" style=3D"background-color: transparent; ">=3D></span><span clas=
s=3D"pln" style=3D"background-color: transparent; "> x</span><span class=3D=
"pun" style=3D"background-color: transparent; ">.</span><span class=3D"pln"=
style=3D"background-color: transparent; ">CreationDate</span><span class=
=3D"pun" style=3D"background-color: transparent; ">);</span><span class=3D"=
pln" style=3D"background-color: transparent; "><br> &nb=
sp; this</span><span class=3D"pun" style=3D"background-color: transparent; =
">.</span><span class=3D"pln" style=3D"background-color: transparent; ">Map=
</span><span class=3D"pun" style=3D"background-color: transparent; ">(</sp=
an><span class=3D"pln" style=3D"background-color: transparent; ">x </span><=
span class=3D"pun" style=3D"background-color: transparent; ">=3D></span>=
<span class=3D"pln" style=3D"background-color: transparent; "> x</span><spa=
n class=3D"pun" style=3D"background-color: transparent; ">.</span><span cla=
ss=3D"pln" style=3D"background-color: transparent; ">ModifiedDate</span><sp=
an class=3D"pun" style=3D"background-color: transparent; ">).</span><span c=
lass=3D"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139);=
">Column</span><span class=3D"pln" style=3D"background-color: transparent;=
"> </span><span class=3D"pun" style=3D"background-color: transparent; ">(<=
/span><span class=3D"str" style=3D"background-color: transparent; color: rg=
b(128, 0, 0); ">"LastUpdatedDate"</span><span class=3D"pun" style=3D"backgr=
ound-color: transparent; ">);</span><span class=3D"pln" style=3D"background=
-color: transparent; "><br> this</span><span cla=
ss=3D"pun" style=3D"background-color: transparent; ">.</span><span class=3D=
"pln" style=3D"background-color: transparent; ">Map </span><span class=3D"p=
un" style=3D"background-color: transparent; ">(</span><span class=3D"pln" s=
tyle=3D"background-color: transparent; ">x </span><span class=3D"pun" style=
=3D"background-color: transparent; ">=3D></span><span class=3D"pln" styl=
e=3D"background-color: transparent; "> x</span><span class=3D"pun" style=3D=
"background-color: transparent; ">.</span><span class=3D"pln" style=3D"back=
ground-color: transparent; ">Email</span><span class=3D"pun" style=3D"backg=
round-color: transparent; ">).</span><span class=3D"pln" style=3D"backgroun=
d-color: transparent; ">Length </span><span class=3D"pun" style=3D"backgrou=
nd-color: transparent; ">(</span><span class=3D"lit" style=3D"background-co=
lor: transparent; color: rgb(128, 0, 0); ">255</span><span class=3D"pun" st=
yle=3D"background-color: transparent; ">).</span><span class=3D"kwd" style=
=3D"background-color: transparent; color: rgb(0, 0, 139); ">Not</span><span=
class=3D"pun" style=3D"background-color: transparent; ">.</span><span clas=
s=3D"pln" style=3D"background-color: transparent; ">Nullable </span><span c=
lass=3D"pun" style=3D"background-color: transparent; ">().</span><span clas=
s=3D"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139); ">=
Unique</span><span class=3D"pln" style=3D"background-color: transparent; ">=
</span><span class=3D"pun" style=3D"background-color: transparent; ">();</=
span><span class=3D"pln" style=3D"background-color: transparent; "><br>&nbs=
p; this</span><span class=3D"pun" style=3D"background-=
color: transparent; ">.</span><span class=3D"pln" style=3D"background-color=
: transparent; ">Map </span><span class=3D"pun" style=3D"background-color: =
transparent; ">(</span><span class=3D"pln" style=3D"background-color: trans=
parent; ">x </span><span class=3D"pun" style=3D"background-color: transpare=
nt; ">=3D></span><span class=3D"pln" style=3D"background-color: transpar=
ent; "> x</span><span class=3D"pun" style=3D"background-color: transparent;=
">.</span><span class=3D"pln" style=3D"background-color: transparent; ">Na=
me</span><span class=3D"pun" style=3D"background-color: transparent; ">).</=
span><span class=3D"kwd" style=3D"background-color: transparent; color: rgb=
(0, 0, 139); ">Column</span><span class=3D"pln" style=3D"background-color: =
transparent; "> </span><span class=3D"pun" style=3D"background-color: trans=
parent; ">(</span><span class=3D"str" style=3D"background-color: transparen=
t; color: rgb(128, 0, 0); ">"UserName"</span><span class=3D"pun" style=3D"b=
ackground-color: transparent; ">).</span><span class=3D"pln" style=3D"backg=
round-color: transparent; ">Length </span><span class=3D"pun" style=3D"back=
ground-color: transparent; ">(</span><span class=3D"lit" style=3D"backgroun=
d-color: transparent; color: rgb(128, 0, 0); ">255</span><span class=3D"pun=
" style=3D"background-color: transparent; ">);</span><span class=3D"pln" st=
yle=3D"background-color: transparent; "><br><br> =
this</span><span class=3D"pun" style=3D"background-color: transparent; ">.=
</span><span class=3D"pln" style=3D"background-color: transparent; ">HasMan=
y </span><span class=3D"pun" style=3D"background-color: transparent; ">(</s=
pan><span class=3D"pln" style=3D"background-color: transparent; ">x </span>=
<span class=3D"pun" style=3D"background-color: transparent; ">=3D></span=
><span class=3D"pln" style=3D"background-color: transparent; "> x</span><sp=
an class=3D"pun" style=3D"background-color: transparent; ">.</span><span cl=
ass=3D"pln" style=3D"background-color: transparent; ">Phones</span><span cl=
ass=3D"pun" style=3D"background-color: transparent; ">).</span><span class=
=3D"pln" style=3D"background-color: transparent; ">Inverse </span><span cla=
ss=3D"pun" style=3D"background-color: transparent; ">();</span><span class=
=3D"pln" style=3D"background-color: transparent; "><br> </span=
><span class=3D"pun" style=3D"background-color: transparent; ">}</span><spa=
n class=3D"pln" style=3D"background-color: transparent; "><br></span><span =
class=3D"pun" style=3D"background-color: transparent; ">}</span><span class=
=3D"pln" style=3D"background-color: transparent; "><br><br></span><span cla=
ss=3D"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139); "=
>public</span><span class=3D"pln" style=3D"background-color: transparent; "=
> class PhoneMap </span><span class=3D"pun" style=3D"background-color: tran=
sparent; ">:</span><span class=3D"pln" style=3D"background-color: transpare=
nt; "> ClassMap</span><span class=3D"pun" style=3D"background-color: transp=
arent; "><</span><span class=3D"pln" style=3D"background-color: transpar=
ent; ">Phone</span><span class=3D"pun" style=3D"background-color: transpare=
nt; ">></span><span class=3D"pln" style=3D"background-color: transparent=
; "><br></span><span class=3D"pun" style=3D"background-color: transparent; =
">{</span><span class=3D"pln" style=3D"background-color: transparent; "><br=
> </span><span class=3D"kwd" style=3D"background-color: transp=
arent; color: rgb(0, 0, 139); ">public</span><span class=3D"pln" style=3D"b=
ackground-color: transparent; "> PhoneMap </span><span class=3D"pun" style=
=3D"background-color: transparent; ">()</span><span class=3D"pln" style=3D"=
background-color: transparent; "><br> </span><span class=3D"pu=
n" style=3D"background-color: transparent; ">{</span><span class=3D"pln" st=
yle=3D"background-color: transparent; "><br> thi=
s</span><span class=3D"pun" style=3D"background-color: transparent; ">.</sp=
an><span class=3D"kwd" style=3D"background-color: transparent; color: rgb(0=
, 0, 139); ">Table</span><span class=3D"pln" style=3D"background-color: tra=
nsparent; "> </span><span class=3D"pun" style=3D"background-color: transpar=
ent; ">(</span><span class=3D"str" style=3D"background-color: transparent; =
color: rgb(128, 0, 0); ">"Phones"</span><span class=3D"pun" style=3D"backgr=
ound-color: transparent; ">);</span><span class=3D"pln" style=3D"background=
-color: transparent; "><br><br> this</span><span=
class=3D"pun" style=3D"background-color: transparent; ">.</span><span clas=
s=3D"pln" style=3D"background-color: transparent; ">Id </span><span class=
=3D"pun" style=3D"background-color: transparent; ">().</span><span class=3D=
"pln" style=3D"background-color: transparent; ">GeneratedBy</span><span cla=
ss=3D"pun" style=3D"background-color: transparent; ">.</span><span class=3D=
"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139); ">Iden=
tity</span><span class=3D"pln" style=3D"background-color: transparent; "> <=
/span><span class=3D"pun" style=3D"background-color: transparent; ">();</sp=
an><span class=3D"pln" style=3D"background-color: transparent; "><br> =
this</span><span class=3D"pun" style=3D"background-co=
lor: transparent; ">.</span><span class=3D"pln" style=3D"background-color: =
transparent; ">Map </span><span class=3D"pun" style=3D"background-color: tr=
ansparent; ">(</span><span class=3D"pln" style=3D"background-color: transpa=
rent; ">x </span><span class=3D"pun" style=3D"background-color: transparent=
; ">=3D></span><span class=3D"pln" style=3D"background-color: transparen=
t; "> x</span><span class=3D"pun" style=3D"background-color: transparent; "=
>.</span><span class=3D"pln" style=3D"background-color: transparent; ">Coun=
tryCode</span><span class=3D"pun" style=3D"background-color: transparent; "=
>).</span><span class=3D"pln" style=3D"background-color: transparent; ">Len=
gth </span><span class=3D"pun" style=3D"background-color: transparent; ">(<=
/span><span class=3D"lit" style=3D"background-color: transparent; color: rg=
b(128, 0, 0); ">5</span><span class=3D"pun" style=3D"background-color: tran=
sparent; ">);</span><span class=3D"pln" style=3D"background-color: transpar=
ent; "><br> this</span><span class=3D"pun" style=
=3D"background-color: transparent; ">.</span><span class=3D"pln" style=3D"b=
ackground-color: transparent; ">Map </span><span class=3D"pun" style=3D"bac=
kground-color: transparent; ">(</span><span class=3D"pln" style=3D"backgrou=
nd-color: transparent; ">x </span><span class=3D"pun" style=3D"background-c=
olor: transparent; ">=3D></span><span class=3D"pln" style=3D"background-=
color: transparent; "> x</span><span class=3D"pun" style=3D"background-colo=
r: transparent; ">.</span><span class=3D"pln" style=3D"background-color: tr=
ansparent; ">Code</span><span class=3D"pun" style=3D"background-color: tran=
sparent; ">).</span><span class=3D"pln" style=3D"background-color: transpar=
ent; ">Length </span><span class=3D"pun" style=3D"background-color: transpa=
rent; ">(</span><span class=3D"lit" style=3D"background-color: transparent;=
color: rgb(128, 0, 0); ">10</span><span class=3D"pun" style=3D"background-=
color: transparent; ">);</span><span class=3D"pln" style=3D"background-colo=
r: transparent; "><br> this</span><span class=3D=
"pun" style=3D"background-color: transparent; ">.</span><span class=3D"pln"=
style=3D"background-color: transparent; ">Map </span><span class=3D"pun" s=
tyle=3D"background-color: transparent; ">(</span><span class=3D"pln" style=
=3D"background-color: transparent; ">x </span><span class=3D"pun" style=3D"=
background-color: transparent; ">=3D></span><span class=3D"pln" style=3D=
"background-color: transparent; "> x</span><span class=3D"pun" style=3D"bac=
kground-color: transparent; ">.</span><span class=3D"pln" style=3D"backgrou=
nd-color: transparent; ">Number</span><span class=3D"pun" style=3D"backgrou=
nd-color: transparent; ">).</span><span class=3D"pln" style=3D"background-c=
olor: transparent; ">Length </span><span class=3D"pun" style=3D"background-=
color: transparent; ">(</span><span class=3D"lit" style=3D"background-color=
: transparent; color: rgb(128, 0, 0); ">50</span><span class=3D"pun" style=
=3D"background-color: transparent; ">).</span><span class=3D"kwd" style=3D"=
background-color: transparent; color: rgb(0, 0, 139); ">Not</span><span cla=
ss=3D"pun" style=3D"background-color: transparent; ">.</span><span class=3D=
"pln" style=3D"background-color: transparent; ">Nullable </span><span class=
=3D"pun" style=3D"background-color: transparent; ">();</span><span class=3D=
"pln" style=3D"background-color: transparent; "><br> &n=
bsp; this</span><span class=3D"pun" style=3D"background-color: transparent;=
">.</span><span class=3D"pln" style=3D"background-color: transparent; ">Ma=
p </span><span class=3D"pun" style=3D"background-color: transparent; ">(</s=
pan><span class=3D"pln" style=3D"background-color: transparent; ">x </span>=
<span class=3D"pun" style=3D"background-color: transparent; ">=3D></span=
><span class=3D"pln" style=3D"background-color: transparent; "> x</span><sp=
an class=3D"pun" style=3D"background-color: transparent; ">.</span><span cl=
ass=3D"pln" style=3D"background-color: transparent; ">Comment</span><span c=
lass=3D"pun" style=3D"background-color: transparent; ">).</span><span class=
=3D"pln" style=3D"background-color: transparent; ">Length </span><span clas=
s=3D"pun" style=3D"background-color: transparent; ">(</span><span class=3D"=
lit" style=3D"background-color: transparent; color: rgb(128, 0, 0); ">255</=
span><span class=3D"pun" style=3D"background-color: transparent; ">);</span=
><span class=3D"pln" style=3D"background-color: transparent; "><br> &=
nbsp; </span><span class=3D"pun" style=3D"background-color: transparent; ">=
}</span><span class=3D"pln" style=3D"background-color: transparent; "><br><=
/span><span class=3D"pun" style=3D"background-color: transparent; ">}</span=
><span class=3D"pln" style=3D"background-color: transparent; "><br></span><=
/code></pre><p style=3D"font-size: 14px; clear: both; word-wrap: break-word=
; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans'=
, sans-serif; text-align: left; ">Additional conventions here:</p><pre clas=
s=3D"lang-sql prettyprint" style=3D"margin-bottom: 10px; padding: 5px; font=
-size: 14px; background-color: rgb(238, 238, 238); font-family: Consolas, M=
enlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bit=
stream Vera Sans Mono', 'Courier New', monospace, serif; overflow: auto; wi=
dth: auto; max-height: 600px; color: rgb(0, 0, 0); line-height: 18px; text-=
align: left; "><code style=3D"font-family: Consolas, Menlo, Monaco, 'Lucida=
Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono=
', 'Courier New', monospace, serif; "><span class=3D"pln" style=3D"backgrou=
nd-color: transparent; ">PrimaryKey</span><span class=3D"pun" style=3D"back=
ground-color: transparent; ">.</span><span class=3D"pln" style=3D"backgroun=
d-color: transparent; ">Name</span><span class=3D"pun" style=3D"background-=
color: transparent; ">.</span><span class=3D"kwd" style=3D"background-color=
: transparent; color: rgb(0, 0, 139); ">Is</span><span class=3D"pln" style=
=3D"background-color: transparent; "> </span><span class=3D"pun" style=3D"b=
ackground-color: transparent; ">(</span><span class=3D"pln" style=3D"backgr=
ound-color: transparent; ">x </span><span class=3D"pun" style=3D"background=
-color: transparent; ">=3D></span><span class=3D"pln" style=3D"backgroun=
d-color: transparent; "> </span><span class=3D"str" style=3D"background-col=
or: transparent; color: rgb(128, 0, 0); ">"Id"</span><span class=3D"pun" st=
yle=3D"background-color: transparent; ">),</span><span class=3D"pln" style=
=3D"background-color: transparent; "><br>ForeignKey</span><span class=3D"pu=
n" style=3D"background-color: transparent; ">.</span><span class=3D"pln" st=
yle=3D"background-color: transparent; ">EndsWith </span><span class=3D"pun"=
style=3D"background-color: transparent; ">(</span><span class=3D"str" styl=
e=3D"background-color: transparent; color: rgb(128, 0, 0); ">"Id"</span><sp=
an class=3D"pun" style=3D"background-color: transparent; ">),</span><span c=
lass=3D"pln" style=3D"background-color: transparent; "><br>DefaultAccess</s=
pan><span class=3D"pun" style=3D"background-color: transparent; ">.</span><=
span class=3D"pln" style=3D"background-color: transparent; ">Property </spa=
n><span class=3D"pun" style=3D"background-color: transparent; ">(),</span><=
span class=3D"pln" style=3D"background-color: transparent; "><br>DefaultCas=
cade</span><span class=3D"pun" style=3D"background-color: transparent; ">.<=
/span><span class=3D"kwd" style=3D"background-color: transparent; color: rg=
b(0, 0, 139); ">All</span><span class=3D"pln" style=3D"background-color: tr=
ansparent; "> </span><span class=3D"pun" style=3D"background-color: transpa=
rent; ">()</span><span class=3D"pln" style=3D"background-color: transparent=
; "><br></span></code></pre><p style=3D"font-size: 14px; clear: both; word-=
wrap: break-word; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans=
', 'DejaVu Sans', sans-serif; text-align: left; "><strong style=3D"backgrou=
nd-color: transparent; ">I need to select top 100 users with Phones and who=
se name starts with "A". But I need to load user objects with Phones in the=
m.</strong></p><p style=3D"font-size: 14px; clear: both; word-wrap: break-w=
ord; color: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sa=
ns', sans-serif; text-align: left; ">So I do this query:</p><pre class=3D"l=
ang-sql prettyprint" style=3D"margin-bottom: 10px; padding: 5px; font-size:=
14px; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, =
Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream=
Vera Sans Mono', 'Courier New', monospace, serif; overflow: auto; width: a=
uto; max-height: 600px; color: rgb(0, 0, 0); line-height: 18px; text-align:=
left; "><code style=3D"font-family: Consolas, Menlo, Monaco, 'Lucida Conso=
le', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Co=
urier New', monospace, serif; "><span class=3D"pln" style=3D"background-col=
or: transparent; ">var users </span><span class=3D"pun" style=3D"background=
-color: transparent; ">=3D</span><span class=3D"pln" style=3D"background-co=
lor: transparent; "><br></span><span class=3D"pun" style=3D"background-colo=
r: transparent; ">(</span><span class=3D"pln" style=3D"background-color: tr=
ansparent; "><br> </span><span class=3D"kwd" style=3D"backgrou=
nd-color: transparent; color: rgb(0, 0, 139); ">from</span><span class=3D"p=
ln" style=3D"background-color: transparent; "> </span><span class=3D"kwd" s=
tyle=3D"background-color: transparent; color: rgb(0, 0, 139); ">user</span>=
<span class=3D"pln" style=3D"background-color: transparent; "> </span><span=
class=3D"kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139=
); ">in</span><span class=3D"pln" style=3D"background-color: transparent; "=
> session</span><span class=3D"pun" style=3D"background-color: transparent;=
">.</span><span class=3D"pln" style=3D"background-color: transparent; ">Qu=
ery</span><span class=3D"pun" style=3D"background-color: transparent; "><=
;</span><span class=3D"kwd" style=3D"background-color: transparent; color: =
rgb(0, 0, 139); ">User</span><span class=3D"pun" style=3D"background-color:=
transparent; ">></span><span class=3D"pln" style=3D"background-color: t=
ransparent; "> </span><span class=3D"pun" style=3D"background-color: transp=
arent; ">()</span><span class=3D"pln" style=3D"background-color: transparen=
t; "><br> </span><span class=3D"kwd" style=3D"background-color=
: transparent; color: rgb(0, 0, 139); ">where</span><span class=3D"pln" sty=
le=3D"background-color: transparent; "><br> </sp=
an><span class=3D"kwd" style=3D"background-color: transparent; color: rgb(0=
, 0, 139); ">user</span><span class=3D"pun" style=3D"background-color: tran=
sparent; ">.</span><span class=3D"pln" style=3D"background-color: transpare=
nt; ">Name</span><span class=3D"pun" style=3D"background-color: transparent=
; ">.</span><span class=3D"pln" style=3D"background-color: transparent; ">S=
tartsWith </span><span class=3D"pun" style=3D"background-color: transparent=
; ">(</span><span class=3D"str" style=3D"background-color: transparent; col=
or: rgb(128, 0, 0); ">"a"</span><span class=3D"pun" style=3D"background-col=
or: transparent; ">)</span><span class=3D"pln" style=3D"background-color: t=
ransparent; "><br> </span><span class=3D"pun" st=
yle=3D"background-color: transparent; ">&&</span><span class=3D"pln=
" style=3D"background-color: transparent; "><br> =
</span><span class=3D"kwd" style=3D"background-color: transparent; color: =
rgb(0, 0, 139); ">user</span><span class=3D"pun" style=3D"background-color:=
transparent; ">.</span><span class=3D"pln" style=3D"background-color: tran=
sparent; ">Phones</span><span class=3D"pun" style=3D"background-color: tran=
sparent; ">.</span><span class=3D"kwd" style=3D"background-color: transpare=
nt; color: rgb(0, 0, 139); ">Any</span><span class=3D"pln" style=3D"backgro=
und-color: transparent; "> </span><span class=3D"pun" style=3D"background-c=
olor: transparent; ">()</span><span class=3D"pln" style=3D"background-color=
: transparent; "><br> </span><span class=3D"kwd" style=3D"back=
ground-color: transparent; color: rgb(0, 0, 139); ">select</span><span clas=
s=3D"pln" style=3D"background-color: transparent; "> </span><span class=3D"=
kwd" style=3D"background-color: transparent; color: rgb(0, 0, 139); ">user<=
/span><span class=3D"pln" style=3D"background-color: transparent; "><br></s=
pan><span class=3D"pun" style=3D"background-color: transparent; ">)</span><=
span class=3D"pln" style=3D"background-color: transparent; "><br> &nb=
sp; </span><span class=3D"pun" style=3D"background-color: transparent; ">.<=
/span><span class=3D"kwd" style=3D"background-color: transparent; color: rg=
b(0, 0, 139); ">Fetch</span><span class=3D"pln" style=3D"background-color: =
transparent; "> </span><span class=3D"pun" style=3D"background-color: trans=
parent; ">(</span><span class=3D"pln" style=3D"background-color: transparen=
t; ">x </span><span class=3D"pun" style=3D"background-color: transparent; "=
>=3D></span><span class=3D"pln" style=3D"background-color: transparent; =
"> x</span><span class=3D"pun" style=3D"background-color: transparent; ">.<=
/span><span class=3D"pln" style=3D"background-color: transparent; ">Phones<=
/span><span class=3D"pun" style=3D"background-color: transparent; ">)</span=
><span class=3D"pln" style=3D"background-color: transparent; "><br> &=
nbsp; </span><span class=3D"pun" style=3D"background-color: transparent; ">=
.</span><span class=3D"pln" style=3D"background-color: transparent; ">Take =
</span><span class=3D"pun" style=3D"background-color: transparent; ">(</spa=
n><span class=3D"lit" style=3D"background-color: transparent; color: rgb(12=
8, 0, 0); ">100</span><span class=3D"pun" style=3D"background-color: transp=
arent; ">)</span><span class=3D"pln" style=3D"background-color: transparent=
; "><br> </span><span class=3D"pun" style=3D"background-color:=
transparent; ">.</span><span class=3D"pln" style=3D"background-color: tran=
sparent; ">ToArray </span><span class=3D"pun" style=3D"background-color: tr=
ansparent; ">();</span><span class=3D"pln" style=3D"background-color: trans=
parent; "><br></span></code></pre><p style=3D"font-size: 14px; clear: both;=
word-wrap: break-word; color: rgb(0, 0, 0); font-family: Arial, 'Liberatio=
n Sans', 'DejaVu Sans', sans-serif; text-align: left; ">And I only got 72 u=
sers.</p><p style=3D"font-size: 14px; clear: both; word-wrap: break-word; c=
olor: rgb(0, 0, 0); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', s=
ans-serif; text-align: left; ">Why? Well, because NHibernate generates sing=
le TOP N select with left outer join and SQL returns several records for th=
e same user entity because some users do have more that one phone. But it's=
all counts against TOP N - so I get 100 records of users joined with phone=
s, but only 72 of them are unique entities.</p><p style=3D"font-size: 14px;=
clear: both; word-wrap: break-word; color: rgb(0, 0, 0); font-family: Aria=
l, 'Liberation Sans', 'DejaVu Sans', sans-serif; text-align: left; ">Is the=
re a proper way to do it?</p>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "=
nhusers" group.<br />
To view this discussion on the web visit <a href=3D"https://groups.google.c=
om/d/msg/nhusers/-/CRs12WZlWOAJ">https://groups.google.com/d/msg/nhusers/-/=
CRs12WZlWOAJ</a>.<br />=20
To post to this group, send email to [email protected].<br />
To unsubscribe from this group, send email to nhusers+unsubscribe@googlegro=
ups.com.<br />
For more options, visit this group at http://groups.google.com/group/nhuser=
s?hl=3Den.<br />
------=_Part_31_20162858.1337846096089--
--
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.
