See updates in a DataReader
Is there a way to see the updates done by other users in a table using a DataReader ?
For example : in my DataReader, I am on the 10th row. Another user updates the 11th row. When I do myReader.Read(), I am seeing the old values. Is there a way to see the new values ?
Same question with new rows.
One Solution collect form web for “See updates in a DataReader”
You might see them with TransIsolation=DirtyReads, but even then it is uncertain.
The only way to get new data for sure is to re-query