My Advice will be: 1-Send a test case to jira; 2-Use hql for now: select c from B b inner join b.A.Cs.c where b.A.Something = :something and c.Other = other
2011/4/28 Krzysztof Kozmic <[email protected]> > Hi Gunnar, > > this won't work either. > > On Apr 28, 9:16 pm, Gunnar Liljas <[email protected]> wrote: > > from c session.Query<C>() > > where c.A.Bs.Any(b=>b.IsActive && .....) > > > > etc. > > > > Maybe... > > > > 2011/4/28 Krzysztof Kozmic <[email protected]> > > > > > > > > > > > > > > > > > Hi > > > > > the scenario is > > > > > A has many Bs > > > A has many Cs > > > > > The query I want to perform is: > > > > > given a set of Bs give me Cs of As of those Bs where Cs meet some > criteria. > > > > > NHibernate (up to latest v3.2 preview) does not support those kind of > > > queries by transition over relationships, and throws > NotSupportedException > > > from VisitAdditionalFromClause method. > > > > > the query looks like: > > > > > from b in session.Query<B>() > > > from c in b.A.Cs > > > where b.IsActive > > > where c.IsActive > > > select c; > > > > > That's actually a quite common kind of queries in my app and I'm a > > > #sadPanda it doesn't work > > > > > Krzysztof > > > > > -- > > > 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. > > -- > 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. > > -- 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.
