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 code downloads for this chapter are found at 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 ...

Get Beginning ASP.NET for Visual Studio 2015 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.