NHibernate Pagination Without Deterministic OrderBy: Inconsistent Result Sets
NHibernate's LINQ provider translates Skip() and Take() into SQL OFFSET/FETCH or LIMIT/OFFSET depending on the configured dialect. A documented behavioral ambiguity arises when these methods are applied without an explicit OrderBy clause, as the database may return rows in an unspecified order, producing inconsistent page results across separate executions.