ExecuteNonQuery does not return affected row count for SP

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Toshan
Posts: 1
Joined: Wed 14 Mar 2012 22:16

ExecuteNonQuery does not return affected row count for SP

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

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

Post Reply