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

    EF Core 3.1 beta - Pagination


      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 " 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 - 64bit Production

      PL/SQL Release - Production

      "CORE Production"

      TNS for Linux: Version - Production

      NLSRTL Version - Production