nHibernate 3 QueryOver with compound from clause -

does know way compound clauses - possible linq objects - nhibernate 3 queryover syntax. know possible linq nhibernate, i'm still trying head around queryover apis.

here example taken msdn linq objects:

var scorequery = student in students                  score in student.scores                  score > 90                  select new { last = student.lastname, score }; 

taken msdn

you can join using queryover api, think you'll need use linq objects flatten result anonymous type.

something this:

session.queryover<student> ()     .joinqueryover (s => s.scores).where (s => s > 90)     .select (s => s.lastname, s => s.scores)     .list ()     .selectmany (s => s.scores, (student, score) => new { last = student.lastname, score = score });