EntityFrameworkCore Skip/take not working in 11.2 — oracle-tech

    Forum Stats

  • 3,715,657 Users
  • 2,242,821 Discussions
  • 7,845,481 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

EntityFrameworkCore Skip/take not working in 11.2

4085346
4085346 Member Posts: 4
edited October 2019 in ODP.NET

An IQueryable<T> that uses Skip and Take (let's say 0 and 20) produces a query with the following line at the end:

OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY

I get the error "ORA-00933: SQL command not properly ended" because this is not valid syntax for 11.2.

Can anyone confirm this is a bug?

4085346

Best Answer

Answers

Sign In or Register to comment.