Linq for NHibernate mode and boot fetch

Question

Is there a way to set fetchmode for more than one object using linq for nhibernate. There seems to be an extension method that only allows me to set up one object. However, I need to set it for several objects. Is it possible? Thanks

Answer 1

just use it more than once.

IList<Entity> GetDataFromDatabase() { var query = session.Linq<Entity>(); query.Expand("Property1"); query.Expand("Property2"); return query.ToList(); } 

Answer 2

The new Linq provider does this a little differently:

 var customers = session.Query<Customer>().Fetch(c => c.Orders).ToList(); 

More details here: http://mikehadlow.blogspot.com/2010/08/nhibernate-linq-eager-fetching.html

Answer 3

As far as I can see, this is not equivalent: SetFetchMode removes the tree of objects, and the Expand method retrieves the Cartesian product.

Answer 4

In response to @Mike Hadlow answer, the choice of the next level (grandchildren) you need to do:

var customers = session.Query<Customer>() .FetchMany(c => c.Orders) .ThenFetchMany(o => o.OrderLines).ToList();