(Akram El Assas) SqlDataReader provides a way of reading a forward-only stream of rows from a SQL Server database. SqlDataReader loads only one record in memory at a time rather than an entire result. SqlDataAdapter loads the entire result in memory at a time.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help