SubSonic SqlQuery, get count of records on paged query

Question

Hi,

I have a large table that must join to multiple Tables, I have a query with serveral condition that user may fill some of them. I used paged method of SqlQuery. Now, how can I get total record count? I want to implement paging on gridview and dont know how many records my query will retun?

Thanks

Answer 1

Paged should return a PageList which has TotalPages and TotalRecords properties on it.