O'Reilly logo

Build Your Own ASP.NET 4 Web Site Using C# & VB, 4th Edition by Cristian Darie, Wyatt Barnett, Timmothy Posey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required