Yes, that should be trivial.
HQL:
select u1.Id, u2.Id from User u1, User u2 where u1.Xyz = u2.Xyz and U1.Id
!= u2.Id
LINQ:
from u1 in session.Query<User>()
from u2 in session.Query<User>()
where u1.Xyz = u2.Xyz && U1.Id != u2.Id
select new { Id1 = u1.Id, Id2 = u2.Id }
/Oskar
2012/10/25 Micke <[email protected]>
> Hi ,
>
> working with mapped entities is the following writable with NH
> functionality ?
>
> select u1.id, u2.id
> from users u1, users u2
> where
> u1.xyz = u2.xyz
> and u1.ID != u2.ID
>
>
> use exists and so on are significant slower, that's why i ask.
>
>
> thnx in advance
> Micke
>
> --
> 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/-/u6zvH-SESW8J.
> 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.
>
--
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.
