ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Developer tools · #nhibernate
Use ICriteria SetMaxResults and SetFirstResult for database-side pagination in NHibernate, with example SQL and limitations.
A decision guide for NHibernate's second-level cache: when to enable it, how providers compare, and how to validate cache hits with statistics.
Learn how to implement NHibernate second-level caching in distributed systems, choosing the right concurrency strategy to prevent stale reads and verifying performance via IStatistics.
Learn how to implement database-level pagination in NHibernate using IQueryable to prevent memory bloat and reduce network latency in large datasets.
Use NHibernate LINQ Fetch and FetchMany to load associations in one query instead of triggering a select for every row.
Learn how to enable, configure, and verify NHibernate’s Second‑Level Cache, including provider setup, TTL settings, and common pitfalls for production use.
Learn how to enable NHibernate’s second‑level cache, pick a consistency strategy, and monitor its effectiveness with built‑in statistics.
Learn how to spot the NHibernate N+1 select problem in lazy‑loaded collections, diagnose it with SQL logging and session statistics, and apply batch‑size or fetch fixes.
A concise architecture note on NHibernate's second‑level cache: requirements, minimal design, trust boundaries, operational checks, failure modes, and when to redesign. Includes concrete SysCache2 configuration, query caching, and a diagnostic checklist.
dotnet