QueryRecordCount and stored procedures

fsharykin · Post by **fsharykin** » Mon 24 Jan 2011 21:42

Hi!
If I use myTable.QueryRecordCount = true with myDataTable.SelectCommand.CommandType = CommandType.StoredProcedure I recieve exception "Error on retrieving record count."

Can you help me?

Shalex · Post by **Shalex** » Tue 25 Jan 2011 17:47

We have reproduced the error. We will investigate the issue and notify you about the results as soon as possible.

Shalex · Post by **Shalex** » Wed 26 Jan 2011 12:22

This is a designed behaviour. We can not support correct work of QueryRecordCount for CommandType.StoredProcedure because there is no possibility to find our the amount of records returned by function with the help of a separate query.
We have corrected the text of the error message to describe this limitation.