Reading data using Dapper

We are going to write some C# code in this section to read data from the database.

We are going to use the popular repository design pattern to structure our data access code. This will allow us to provide a nice centralized abstraction of the data layer.

We are going to start by creating a data repository class to hold all of the queries we are going to make to the data. We are going to create C# classes to hold the data we get from the database called models.

Creating the repository class

Let's create a class to hold all of the methods for interacting with the database:

1. In the Solution Explorer, right-click on the project, select the Add menu, and then choose the New Folder option.
2. A new folder...