Data readers provide ___________ access to data, which can be beneficial for performance when reading large datasets.

  • Bidirectional
  • Forward-only
  • Random
  • Sequential
Data readers in .NET, such as SqlDataReader, provide forward-only access to query results. This means that data can only be read sequentially in a forward direction, starting from the first record and moving towards the last. Forward-only access is beneficial for performance when dealing with large datasets because it minimizes memory consumption and overhead associated with caching data. By reading data sequentially, data readers optimize resource usage and facilitate efficient processing of query results, especially in scenarios involving large volumes of data.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *