I'm trying to debug a batch job, and while I got the code to break at the run method, when I attempt to step through the while select statement, the debugger skips all the way to the last statement of the while select code block (at the last iteration as well). I've double checked that the while select will return at least 1 or more rows, and it always skips to the last statement in the code block which means it is entering it. I don't understand why this happens, and need to know if there's any way to force the debugger to break at the start of the code block. I'm guessing that sql statements in managed code cannot be debugged?
Here is the while select statement. The breakpoint inside the block doesn't get hit:
The next instruction stopped at is all the way at the end of the while select block, on the last iteration: