Friday, 02 December 2005
ADO.NET timeouts when filling a DataAdapter in the middle of a transaction
I had a transaction comprised of about 5 commands, and in the middle of it, i needed to do a SELECT on a table to know what values to insert for one of the commands. I encountered a timeout just after i called Fill on the DataAdapter. it took me a while to figure out that it was because the transaction had already taken out a lock on the table i was selecting from. makes sense now, but i spent ages on it! just posting it here in case anyone else runs into the same problem.
Friday, 02 December 2005 12:26:22 (GMT Standard Time, UTC+00:00) .Net General | .Net Windows Forms | Asp.Net | Database