The paging using a datapager + ListView + LinqDataSource is really slick and easy to setup but I don't see where I can dig in and see whats going on. Ok maybe its just me but I don't like not knowing how things are working under the covers.
Everything I have read says in SQL 2005 this will use efficient methods to only pull back the number of rows you need and won't pull back 1000 rows to show you 10. So what kind of sql does this generate and were is it returning the total number of pages in the results?
I have the same issue with the examples I have seen using custom paging and the new SKIP and TAKE methods. The don't talk about anywhere, where you would get the total pages to be able to build the paging and know what SKIP value to send.