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 ?

  • EF ObjectQuery<T> Context, Parameters, Connection properties equivalent on DbSet<T>
  • How to find all connected subgraphs of an undirected graph
  • How to get date time 01/03/2017 16:06:21 AM format in SQL Server
  • SQL Server Tables Named With dbo Schema
  • Why does my trigger not fire?
  • Entity Framework Migrations renaming tables and columns
  • Same question with new rows.

  • Overflow exception when reading decimal values from SQL Server
  • Prevent ADO.NET from using sp_executesql
  • How to Prepare an ADO.NET Statement which includes an NText (clob) parameter
  • Retrieve number of columns in SQL Table - C#
  • Stored Procedure or Bulk Statements
  • Is there anything faster than SqlDataReader in .NET?
  • 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

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.