In the last three chapters, you learned some of the important concepts
of data access and presentation. You learned how to use the
SqlConnection class to establish a connection to the
database, you learned how to use the
to execute a query on a database table, and you learned how to return the
results of the command into an
SqlDataReader for use
within the application.
In this chapter, we’ll discuss the alternatives to using the
SqlDataReader object for retrieving
data from your database. For starters, it’s important to understand that
SqlDataReader has both advantages and disadvantages.
The two main points you need to keep in mind about
It represents the fastest method available ...