That is all fine and dandy but I need to bind that in an asp.net page with pagination (emphasis on paging).
Use the paging of the GridView, all results will be fetched eachtime you'd select a page, and the grid will just display the needed records. (Not effecient)
Implement paging in your SP, add a couple of parameters for the page number & page size.
I also need to be able to keyword search and filter within this resultset.
Maybe you need to project the results into an entityCollection (if possible), and use the client side EntityView filtering.