FbCommand.ExecuteNonQuery return value [DNET927]

[firebird-automations]

Submitted by: @cincuranet

The FbCommand.ExecuteNonQuery should return -1 for everything except insert, update, delete, according to "spec".

https://docs.microsoft.com/en-us/dotnet/api/system.data.common.dbcommand.executenonquery

"For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1."

Commits: da206eb

[firebird-automations]

Modified by: @cincuranet

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: vNext [ 10915 ]

[viegasfh]

Hi!

I am executing an INSERT .... RETURNING statement and it is returning -1. Shouldn't it be the number of rows affected?

[cincuranet]

@viegasfh The "problem" is, that INSERT ... RETURNING Firebird reports as "stored procedure" command type.

[viegasfh]

OK, thanks! I have added the condition to test it against -1.