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.
© Copyright 2017 Tim Mackey