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?

themarcuz · Accepted Answer · 2012-03-16 15:09:45Z

13

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);

edited Mar 16, 2012 at 15:09

themarcuz

2,5916 gold badges36 silver badges54 bronze badges

answered Jul 2, 2010 at 10:06

Steve Strong

2713 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nicolas Cadilhac Over a year ago

Fetch must be placed after Where or you will get an exception.

leora Over a year ago

@Nicolas Cadilhac, @Steve Strong - how do you add a where after a ThenFetch ?? Nicolas response says the above doesn't work but its the accepted answer so i am confused

leora Over a year ago

@Nicolas Cadilhac, @Steve Strong - When i run this, i get "notsupported Exception"

Nicolas Cadilhac Over a year ago

@ooo: as you and I mentioned, Fetch and ThenFetch must be the last clause. I accepted the answer knowing that I added a comment to tell about this constraint. In another SO question, I tried to know if there is a workaround (I need some Where clause after a fetch and paged result) but it seems the current status of LinqToNH does not allow it. So to answer your question, you can do it only with HQL or Criteria API. Also I don't know why Linq does not honnor the lazy statement set in the mapping.

Community · Accepted Answer · 2017-05-23 10:32:39Z

-2

For me this thread solve problem.

Linq for NHibernate - filtering on <many-to-one> foreign key causes extra lookup

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

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Jul 4, 2010 at 18:07

Francis

11

1 Comment

ILya Over a year ago

there is no QueryOptions in NHibernate 3

Collectives™ on Stack Overflow

Eager load while using Linq in NHibernate 3

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related