Chapter 10: Setting Up Our Database Project
In this and the following two chapters, we will be improving the performance of your database-based applications. In this chapter, we will be setting up our relational database and the code to access that database. In the next chapter, we will write benchmarks to test the performance of the different frameworks, which consist of Entity Framework, Dapper, and ADO.NET. Finally, in Chapter 12, Responsive User Interfaces, we will learn how to improve the performance of SQL Server and Cosmos DB.
Data is extensively used in all aspects of our daily lives. In today's world of big data, the volume of data being collected and stored for all kinds of analysis is phenomenal. When working with data, performance can slow down exponentially as the size of your data grows. And depending on how much data you have to process, time is often critical.
In this chapter, we will create a database and populate it, and we will write the code to access...
