gistfile1.cs

var query = from foo in session.Query<Foo>()
            from bar in foo.Something.Bars
            select anythingReally;

// LINQ provider throws exception complaining
// about second 'from', but in reality it complains about the 'Something' between foo and Bars
var result = query.ToList();