ExecuteNonQuery returns 0
Posted: Tue 27 Jun 2017 15:57
Hello.
In our software company, we bought mysql devart connector to replace the mysql.data original connector for our software application which creates large transactions through {Devart.Data.MySql.MySqlCommand} sending 'updates' and 'insert' commands. Mysql.Data connector returns 1 if there is 1 row matched even if it there are 0 rows changed.
On the other hand, Devart.Data.Mysql connector returns 0 if there are 0 rows changed even if there is 1 row matched as the image attached below.
I cannot change the source code of my software application, and I would like to know how to retrieve the rows matched and the rows changed according to the Devart.Data.MySql.MysqlCommand class, but I havenĀ“t been able to achieve it due protection level.
How do you think I could do that ?
Thank you very much.
In our software company, we bought mysql devart connector to replace the mysql.data original connector for our software application which creates large transactions through {Devart.Data.MySql.MySqlCommand} sending 'updates' and 'insert' commands. Mysql.Data connector returns 1 if there is 1 row matched even if it there are 0 rows changed.
On the other hand, Devart.Data.Mysql connector returns 0 if there are 0 rows changed even if there is 1 row matched as the image attached below.
I cannot change the source code of my software application, and I would like to know how to retrieve the rows matched and the rows changed according to the Devart.Data.MySql.MysqlCommand class, but I havenĀ“t been able to achieve it due protection level.
How do you think I could do that ?
Thank you very much.