Eager load while using Linq in NHibernate 3

Question

I need help with eager loading in with Linq in NHibernate 3 trunk version.

I have a many-to-many relationship like this:

public class Post
{
    public int Id {get;set;}
    public IList<Tag> Tags { get;set;} 
    .
    .
    .
}

Now I have the following mapping in Fluent NHibernate

public class PostMap:ClassMap<Post>
{
    public PostMap()
    {
        Table("Posts");
        Id(x => x.Id);
        .
        .
        HasManyToMany(x => x.Tags)
            .Table("PostsTags")
            .ParentKeyColumn("PostId")
            .ChildKeyColumn("TagId")
            .Not.LazyLoad(); // this is not working.. 
    }
}

Now while fetching the posts, I need the Tags also to eager load. I know that it is possible with Criteria API and HQL and the SetFetchMode is what I should use. But is there are way to use SetFetchMode when using Linq?

Answer 1

It's not possible yet, but Steve Strong has planned to implement it.

Answer 2

Support for this went into the trunk sometime ago; the syntax is be something like

var query = session.Query().Fetch(p => p.Tags).Where(bla bla);

If Tags in turn had another relationship, you can do:

var query = session.Query().Fetch(p => p.Tags).ThenFetch(t => t.SomethingElse).Where(bla bla);

Answer 3

For me this thread solve problem.

http://stackoverflow.com/questions/1677301/linq-for-nhibernate-filtering-on-many-to-one-foreign-key-causes-extra-lookup

var linqsession = session.Linq(); linqsession.QueryOptions.RegisterCustomAction(c => c.SetResultTransformer(new DistinctRootEntityResultTransformer())); var feedItemQuery = from ad in linqsession.Expand("Ads") where ad.Id == Id select ad