Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

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
2 comments
235 views