You use a DbDataReader to access a single result set. As you iterate through the result set, you need to check whether you have read all the rows in the result set.

What should you do?

The DbDataReader.Read method advances the reader to the next record in a result set and returns True if there are more rows; otherwise it returns False.

The DbDataReader.NextResult method returns True if a subsequent result set is available.