…erver (NH-2977 plus some followup changes).
…nd made MsSql20xxDialect.GetLimitString() implementations more consistent.
- Added limit SQL generation for SQL Server queries with comments, common table expressions, and stored procedure invocations. - Modified loader to fall back to client-side limit/offset behavior if dialect does not support generation of server side limit/offset SQL for a given (custom) SQL statement.
…H-2977 is picked from master.
… statements. Modified SqlString.Parse() to ignore parameter references in SQL comments.
… for NH-3132 (already fixed on master). sqlServerOdbc/NHibernate.Test.last-results.xml: Allow failure WillCloseWhenUsingDTC(), which hade been accidentally flagged as successful.
…ssues NH-3132, NH-2819, NH-2726, NH-3244 and NH-3058.
…ods with various type constraints. Based on pull request #142 from cremor, but leaving out the incomplete parts. Also took the opportunity for some cleanup. NH-3244.
…l in how we get the MethodInfo for the target method. The previous code would get the closed generic method on .Net 2.0, but the open generic method definition on .Net 4.0. Now, explicitly reference the type arguments of the generated method, so we always get the closed generic method. This fixes NH-2819, NH-2726.
…lity. Running the test code in NH-3638 demonstrates that the bug disappears with this change. No unit test committed since reproduction requires relatively complex long-running scenario.
Hql/Ast/HqlFixture.UnaryMinusBeforeParenthesesHandledCorrectly(): Don't depend on temp tables. Stateless/StatelessSessionFixture.cs: Allow for dialects that don't have fractional seconds in timestamp versions. sqlServerCe/NHibernate.Test.last-results.xml: Allow UnaryMinusBeforeParenthesesHandledCorrectly() to fail (rest of the suite does) due to lack of Date support in dialect. Already fixed on master.
…oat equality conversion which might cause accuracy issues and which isn't relevant to the test.
…t (to resolve some failing tests, e.g. DbVersionFixture.CollectionNoVersion()).