How to eager load Child Collections (Ex: Blog.Post.Comments) Directly Using QueryOver In NHibernate 3.1

random

session.QueryOver<Blog>()
    .Fetch(b => b.Posts).Eager // If you don't add this, the following will not work
    .Fetch(b => b.Posts.First().Comments).Eager // The trick here is using ".First()" after the collection
    .List();

Result Query (SQL CE 4.0):

SELECT
    this_.Id as Id0_2_,
    this_.Title as Title0_2_,
    posts2_.Blog_id as Blog3_4_,
    posts2_.Id as Id4_,
    posts2_.Id as Id2_0_,
    posts2_.Title as Title2_0_,
    comments3_.Post_id as Post3_5_,
    comments3_.Id as Id5_,
    comments3_.Id as Id1_1_,
    comments3_.Title as Title1_1_
FROM
    "Blog" this_
left outer join
    "Post" posts2_
        on this_.Id=posts2_.Blog_id
left outer join
    "Comment" comments3_
        on posts2_.Id=comments3_.Post_id