Beginning ASP.NET for Visual Studio 2015

Chapter 10Working with Data—Advanced Topics

What you will learn in this chapter:

• Integrating pagination and sorting into an application
• Different approaches to inserting and updating data
• Non-Entity-Framework approaches to database access
• Caching in a web application
• Practical advice about using databases in web applications

Code downloads for this chapter:

The wrox.com code downloads for this chapter are found at www.wrox.com/go/beginningaspnetforvisualstudio on the Download Code tab. The code is in the chapter 10 download and individually named according to the names throughout the chapter.

You learned a lot of information about databases in the last chapter, including how to set them up and interact with them. This chapter takes a deeper dive into the process of interacting with the database, including connecting the pages that you created in earlier chapters.

Two of the more important usability items when looking at a list of information are sorting and pagination. Sorting enables users to see items in their preferred order rather than in a database-defined order, while pagination is the capability to break long lists of information into sets of defined size, or items on a page as pagination is the breaking of a data list into small pages of data. Using pagination enables the user to work with smaller sets of information at one time, providing both a reprieve from the intimidation of an extremely long list as well as faster performance resulting from transferring and ...