ExecuteNonQuery does not return affected row count for SP

ExecuteNonQuery does not return affected row count for SP

Postby 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
Toshan
 
Posts: 1
Joined: Wed 14 Mar 2012 22:16

Postby 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
Pinturiccio
Devart Team
 
Posts: 1997
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle