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.

Reply via email to