Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Paging with LINQ

Paul NewmanJun 24 2011 — edited Jan 12 2012
I see that beta 2 is just released. But it's a real shame this issue isn't fixed (taken from the readme):

+14. SORT operation is not applied to the entire result set prior to the SKIP / TAKE operators.+

It means you can't really do paging, which is essential in many if not most apps. The sorting is currently done after the paging (i.e. within the page), which is obviously no good. This is a massive pain for us. Any news on a fix?

Typical code goes like this:

(from t in T_USER orderby t.Name select t.Name).Skip(10).Take(5)

Thanks
Paul

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 9 2012
Added on Jun 24 2011
#odp-net
2 comments
315 views