I am using an ADO.Net SqlDataReader to read through a rather large query. As I process the data I want to execute an "update set x = y" statement on the database using a different command and a different connection (different connect string, timeout value is different) for the row I just read. At runtime I get an sql exception saying my update command timed out. (timeout expired). But the same, except "update" statement works fine outside the app!
Does a SqlDataReader lock the records it is reading? I thought it was "fastforward read-only"?
Is there a parameter I need to set?
Does a SqlDataReader lock the records it is reading? I thought it was "fastforward read-only"?
Is there a parameter I need to set?