Location: The Official Oracle Wiki

Discussion: Why Doesn't the ODP.NET provide built in paging that is easier to use?Reported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 1 post

JamesKW
Why Doesn't the ODP.NET provide built in paging that is easier to use?
Oct 29 2009, 8:17 PM EDT | Post edited: Oct 29 2009, 8:17 PM EDT
I realize you can use the RowSize and FetchSize to accomplish this but why not provide a nice way of doing this like the code sample below? Besides, you have to make a round trip to get the RowSize before you are able to do this. I also know you can use SQL with rownum to do this as well, but that isn't really part of ODP.NET.

SqlDataReader sqlDataReader = sqlCommand.ExecutePageReader(CommandBehavior.CloseConnection, 1, 25);

Many thanks,
--James 1  out of 1 found this valuable. Do you?    

Sign in to be the first to reply.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Free webinar on Enterprise 2.0, hosted by Sierra Atlantic Free webinar on Oracle BI, hosted by Sierra Atlantic and Oracle Complimentary webinar on AIA, hosted by Sierra Atlantic and Oracle
Sierra Atlantic, Inc. NamedAssemblies Oracle Tweeters
Lista Blogów o ORACLE Getting or Creating queryid for current statement SQLPro
Tracking Oracle License usage start isql plus Eventos MK Tecnología