juniorADO.NET
What is SqlDataReader?
Updated Feb 20, 2026
Short answer
SqlDataReader provides fast, forward-only, read-only access to data.
Deep explanation
Works in connected mode and is highly performant.
Real-world example
TypeScript
``tsSqlDataReader reader = cmd.ExecuteReader();while(reader.Read()){ Console.WriteLine(reader["Name"]);}``Common mistakes
- Forgetting to close reader
- Trying to scroll backward
Follow-up questions
No follow-up questions available yet.