NHibernate FlushMode.Auto Produces Divergent Auto-Flush Decisions Across Query APIs
NHibernate's automatic flush behavior under FlushMode.Auto is documented as a heuristic that flushes pending changes before a query only when the session determines the query might touch the same entity or table spaces. In workflows that mix HQL, Criteria, QueryOver, and LINQ against the same transaction, developers face an unresolved consistency decision: w