ExecuteNonQuery does not return affected row count for SP

Toshan · Post by **Toshan** » Wed 14 Mar 2012 23:00

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

Pinturiccio · Post by **Pinturiccio** » Mon 19 Mar 2012 11:32

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