Hello all,
I have this small query, written in HQL :
return Session.CreateQuery("from Player p where p.Visible and exists
(from PlayerInTeam pit where pit.Player = p and pit.Roster.Team
= :teamId)")
.SetParameter("teamId", team.Id)
.Enumerable<Player>();
I'd like to write it using the new QueryOver syntax.
Currently, I have:
return Session.QueryOver<Player>()
.Where(p => p.Visible)
.WithSubquery.WhereExists(QueryOver.Of<PlayerInTeam>().Where(pit
=> pit.Roster.Team == team))
.List();
But this throws this exception:
NHibernate.QueryException: Cannot use subqueries on a criteria without
a projection.
Could you tell me what's wrong?
Thanks in advance
--
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.
