2 Replies Latest reply on Jul 7, 2020 8:57 AM by user5943561

    EF Core 3.1 beta - Pagination

    user5943561

      Hi all,

       

      I tried the beta for EF Core with a paginated query (i.e using Skip and take in lambda)

       

      The generated SQL looks like :

      select ... from ... where ... OFFSET :p_1 ROWS FETCH NEXT :p_2 ROWS ONLY

       

      However, my server answers : SQL Error [933] [42000]: ORA-00933

       

      Is this because my server version is not supported ? I've seen that the EF core beta supports "11.2.0.4 and higher" but I do not think that the OFFSET .. FETCH NEXT has been introduced before 12c ...

       

      Here are the details of my server version:

       

      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

      PL/SQL Release 11.2.0.1.0 - Production

      "CORE 11.2.0.1.0 Production"

      TNS for Linux: Version 11.2.0.1.0 - Production

      NLSRTL Version 11.2.0.1.0 - Production