I tried searching for this particular answer but with no successful results and this is my last hope.
I am having a timeout error when updating 516rows in a table, but when the table only has 56 rows in it, it updates each row successfully, but when there is 516 rows returned to be updated and i loop through the first row and try and update it, i get the following error
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Note, when the table consist of only 56 it works fine.
I tried setting the commandTimeOut to 0 and 100 but nothing seems to work
Can anyone advice me on what to do?