Blog76.4K views1,860 votes0 replies1,825 following
NHibernate Paging: Keeping Skip/Take in SQL When Fetching Collections
Join-fetching a collection in NHibernate can duplicate root rows and force first/max results into memory. Page identifiers instead, then batch the graph with future queries.