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