ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

Postby idem84 » Fri 15 Aug 2014 14:45

Hi
I have a question for specific commandtexts ("truncate table" detected) and different providers result in ExecuteNonQuery...

Sample code:

...
uniCommand.CommandText="truncate table anytable"
var res = uniCommand.ExecuteNonQuery(); //Works ok, but return value of -1 if provider is SqlServer; and returns 0 if provider is MySql
...

Thanks in advance
idem84
 
Posts: 50
Joined: Thu 04 Apr 2013 19:12

Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

Postby Pinturiccio » Mon 18 Aug 2014 10:51

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

Postby Pinturiccio » Wed 03 Sep 2014 12:35

We have fixed the bug with returning 0 instead of -1 for all statements except UPDATE, DELETE, INSERT statements with MySQL. We will post here when the corresponding build of dotConnect Universal is available for download.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

Postby Pinturiccio » Thu 04 Sep 2014 14:14

New build of dotConnect Universal 3.50.736 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/universal/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=30320
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect Universal