What is the purpose of the SqlDataReader class in ADO.NET?
- Executes SQL commands and returns a result set
- Provides a way to read a forward-only stream of rows from a SQL Server database
- Represents a disconnected architecture for interacting with a database
- Retrieves data from the database and populates a DataSet
The purpose of the SqlDataReader class in ADO.NET is to provide a way to read a forward-only stream of rows from a SQL Server database. It enables efficient data retrieval and processing by sequentially reading data from the database without the need to cache the entire result set in memory.
Loading...
Related Quiz
- When working with LINQ to Entities, what is eager loading, and how can it impact performance?
- Scenario: You are developing an application that needs to query a list of customer objects stored in memory. Which LINQ technology would you choose for this task?
- Explain the concept of data binding expressions in ASP.NET and give an example.
- Can you explain the concept of "alternating items" in the DataList control and why it might be useful?
- What is the significance of the "Connection Lifetime" property in connection string settings?