Fetch vs FetchMany in NHibernate Linq provider

linq nhibernate fetch eager-loading
Simon picture Simon · Dec 9, 2010 · Viewed 25.7k times · Source

NHibernate eager loading can be done using Fetch and FetchMany, as described in NHibernate Linq Eager Fetching on Mike Hadlow's blog.

What is the difference between these two methods and under what circumstance would each be used?

Answer

Diego Mijelshon picture Diego Mijelshon · Dec 9, 2010

Fetch should be used for references and FetchMany for collections.

This is particularly important because only FetchMany can be combined with ThenFetchMany to fetch "grandchildren" collections.

Example:

session.Query<User>()
       .FetchMany(u => u.Orders)
       .ThenFetchMany(o => o.OrderItems)

Related questions

Linq for NHibernate and fetch mode of eager loading

Is there a way to set the fetchmode to eager for more than one object using linq for nhibernate. There seems to be an expand method which only allows me to set one object. However I need to set it …

Read More
Linq to NHibernate

I have been looking around for some example projects or tutorials on Linq to Nhibernate. Does anyone know of any good ones?

Read More
NHibernate vs LINQ to SQL

As someone who hasn't used either technology on real-world projects I wonder if anyone knows how these two complement each other and how much their functionalities overlap?

Read More