Efficiently Paging Through Large Amounts of Data:
Step 3-Returning the Precise Subset of Records
This step of the VIDEO TUTORIAL will demonstrate in adding GetProductsPaged( ) method (to the DAL) that accepts ‘startIndex’ and ‘maximumRows’ as parameters for returning a subset of the Total Number of Records for custom paging purposes. In order to accomplish this, a new ranking function ROW_NUMBER is utilized. Finally, a wrap around method for this newly created data access layer method is created in the ProductsBLL business logic layer. For detailed information and source code for this step, please refer to the original article.