Paging Results

May 24, 2008 at 1:46 AM
Hi I've been using the repository factory on our current project and overall it has been a good experience. I'm looking for advice on how to implement paging of large result sets. My stored procedure takes in the following paging parameters:

PageIndex      int               The page number to return
PageSize         int               The maximum number of records per page
TotalRecords   int out        The total number of records returned for this query

The TotalRecords is passed back to the presentation layer and is used by my paging control to display the total number of records. My question is how do I get the value for the TotalRecords out parameter? The Insert Factory is able to retrieve output parameters but I don't how to retrieve output parameter values using the SelectionFactory.