Page 1 of 1

QueryRecordCount and stored procedures

Posted: Mon 24 Jan 2011 21:42
by fsharykin
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?

Posted: Tue 25 Jan 2011 17:47
by Shalex
We have reproduced the error. We will investigate the issue and notify you about the results as soon as possible.

Posted: Wed 26 Jan 2011 12:22
by Shalex
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.