Page 1 of 1

ExecuteNonQuery does not return affected row count for SP

Posted: Wed 14 Mar 2012 23:00
by Toshan
Hi,

http://www.devart.com/dotconnect/oracle ... Query.html

ExecuteNonQuery does not return affected row count when calling stored procedure. That's not how Microsoft provider works.

Is there any way we can get the rows affected using DevArt provider?

Regards

Toshan

Posted: Mon 19 Mar 2012 11:32
by Pinturiccio
Toshan wrote:ExecuteNonQuery does not return affected row count when calling stored procedure. That's not how Microsoft provider works.
If you mean SqlClient when saying Microsoft provider, then dotConnect for SQL Server returns the number of rows affected by stored procedure. But Oracle has different behavior. Such topic was discussed on our forum. For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=20771