ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EntityFrameworkCore Skip/take not working in 11.2

User_M90MPSep 13 2019 — edited Oct 12 2019

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?

This post has been answered by Alex Keh-Oracle on Sep 13 2019

Jump to Answer

Added on Sep 13 2019

#odp-net

2 comments

2,117 views