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?
Support for this went into the trunk sometime ago; the syntax is be something like
var query = session.Query<Post>().Where(bla bla).Fetch(p => p.Tags);
If Tags in turn had another relationship, you can do:
var query = session.Query<Post>().Where(bla bla).Fetch(p => p.Tags).ThenFetch(t => t.SomethingElse);