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.
