I have an IQuery that has some parameters and I set the paging options. I execute this query to get the results, but I also need to get the total count of items that the query would return if I wasn't using paging.

Is there anyway to get the count without completey recreating the query, parameters and all?

An excellent question, and one to which I don't have an answer, sorry! :(

I've been constructing my queries in parts as separate strings.; the SELECT clause, the FROM clause (incl. joins) and the WHERE clause.

When I need to get the count I just create a new query with the query string stating "SELECT COUNT() ", append the FROM and WHERE clause strings and then re-add the all the parameters.

A bit of a pain, but it works.

If anyone else out there has a more elegant solution I'd love to hear it too!

Cheers,

Symon.

I'm not even sure how to do this in plain SQL. How would you do this with plain ADO.NET and SQL?

well with regular sql I would have a stored procedure that did the paging which also returned an output paramter of the count.

I guess with dynamic sql you would need 2 SqlCommands also.

This won't be much of an issue once the Count property feature of ICriteria gets completed. I wish this would get done before version 1.0 release.