Chapter 9: Working with Data in .NET 5

One of the essential components for any web application are the ability to persist data to a permanent data store; some forethought in picking the right persistent store can help a system scale better in the future.

One of the common operations in any web application is to log in to the system, perform some reads/updates, and log off, and then come back later to see whether the changes were retained. Databases play a significant role in persisting these actions, which are typically called user transactions. Apart from transactional data, for monitoring and debugging purposes, an application may additionally need to store logging data and auditing data, such as who modified the date. An important step for designing any such application is to understand the requirements and design the database accordingly. It's also important to choose/design a database according to various data retention requirements and any data protection policies, such...