|Subject||Firebird ADO.NET: ExecuteNonQuery Returns -1 On Successful Insert|
I am using the Firebird 2.5 Embedded Edition with the Firebird ADO.NET provider version 5.5 or 5.7. I am not sure which, since it has been so long since I set up the references for my project and the assembly being used is not taken from the actual provider library that has all the files in it..
In any event, during a test of my current application development I successfully inserted a record into a table using a Firebird stored procedure with the ADO.NET ExecuteNonQuery method, which should return a "records affected" count of "1".
Instead, I am finding that the returned "records affected" count is "-1".
I have never seen this before with all the other database engines I have worked with over the years. Nonetheless, I believe I have seen this issue raised with Firebird ADO.NET before but some time ago.
Does anyone have any idea as to what is causing this?