Thanks Richard, I will try that. Though I was there was a simpler way to do it... maybe I'll get used to the syntax...
On Mon, Nov 1, 2010 at 3:37 AM, Richard Brown (gmail) < [email protected]> wrote: > I think this would work: > > Course courseAlias = null; > User userAlias = null; > > var statesForUser = > QueryOver.Of<Enrollment>() > .JoinAlias(e => e.User, () => userAlias) > .JoinAlias(e => e.Course, () => courseAlias) > .Where(() => userAlias.UserName == “Hoang”) > .Select(() => courseAlias.StateName); > > var courses = > session.QueryOver<Course>() > .WithSubquery.WhereProperty(c => c.StateName).In(statesForUser) > .List(); > > > http://nhforge.org/blogs/nhibernate/archive/2009/12/17/queryover-in-nh-3-0.aspx#Subqueries > > Regards, > Richard > > > *From:* Hoang Tang <[email protected]> > *Sent:* Sunday, October 31, 2010 5:10 AM > *To:* [email protected] > *Subject:* [nhusers] How do I do a subselect with QueryOver? > consider the following Hql I would like to convert it to QueryOver > > from Course c where c.StateName in (select e.Course.StateName from > Enrollment e where e.User.UserName ='Hoang' ) > > > > > -- > 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]<nhusers%[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]<nhusers%[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.
