#in-memory

Pagination with collection fetch: ambiguous row counts and in-memory fallback

NHibernate's Take/Skip normally generates dialect-specific SQL for pagination, but when a collection is eagerly fetched (e.g., Fetch(p => p.Children) ), the query may fall back to in-memory pagination after loading the full result set. This makes the number of distinct entities returned less than the requested page size and leaves the total row count ambi

Community & Careers · Editorial question

fetchpaginationnhibernate