Nhibernate query over with multiple fetch and multiple conditions

Question

How can I get same result with NHibernate QueryOver when using entity framework linq like this.

var result = items
   .include("subEntity1")
   .include("subEntity2")
   .include("subEntity3")
   .where(...).skip(x).take(y);

Radim Köhler · Accepted Answer · 2014-02-24 08:19:19Z

3

A syntax with QueryOver could look like this:

var query = session.QueryOver<MyEntity>()
    // force the collection inclusion
    .Fetch(x => x.Collection1).Eager
    .Fetch(x => x.Collection2).Eager
    ...
    // force the relations inclusion
    .Fetch(x => x.SubEntity1).Eager
    .Fetch(x => x.SubEntity2).Eager
    ...
    // paging
    .Skip(x)
    .Take(y);

var list = query
     .List<MyEntity>();

Sources:

answered Feb 24, 2014 at 8:19

Radim Köhler

124k48 gold badges243 silver badges343 bronze badges

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

2 Comments

user656822 Over a year ago

I try this one but I'm getting duplicate entity in the result

Radim Köhler Over a year ago

Yes, that's the impact of the Fetch - collection. It always results in carthesian product. The appropriate way is in fact to do NOT Fetch. Change your mapping to a use batch-size, which will end in more then 1 query, but still very efficient. Please, check stackoverflow.com/a/20970816/1679310 or stackoverflow.com/a/19287008/1679310

Collectives™ on Stack Overflow

Nhibernate query over with multiple fetch and multiple conditions

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related