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.

Reply via email to