I would suggest to do following:
1. Create stored procedure, which taks as input parameter page size and page number.
2. Stored procedure should return subset of data
3. Create one more stored procedure which will tell whole dataset size.
4. It may be worthy to analyze SQL query execution plan...
I would suggest couple of solutions:
1. Use Class library, and put there needed functionality
2. From design prospective, make sure to use some kind of dependency injection and mocking mechanism for dealing with TDD.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.