search

sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.06k stars 499 forks source link

--Oracle11g does not support, "OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY " #672

Closed mummyildiz closed 1 year ago

mummyildiz commented 1 year ago

SELECT t.* FROM personel t WHERE t.t_sicilno is not null ORDER BY (SELECT 0 FROM DUAL)

--Oracle11g does not support OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

can we change it for oracle version?

ahmad-moussawi commented 1 year ago

You are looking for UseLegacyPagination.

var oracleCompiler = new OracleCompiler { UseLegacyPagination = true };