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
ExecuteNonQuery returns -1 for SqlServer and 0 for MySql
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql
New build of dotConnect Universal 3.50.736 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.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
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.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