Chapter 12Advanced Data Access
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 SqlCommand class
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
SqlDataReader are:
-
It represents the fastest method available ...
Get Build Your Own ASP.NET 4 Web Site Using C# & VB, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
