Hands-On RESTful Web Services with ASP.NET Core 3

Implementing a data access layer using Dapper

Another standard tool that provides a way to implement a data access layer is Dapper. We have already taken an overview of Dapper, but this section will cover in more detail how to deal with this package and how to use it to implement a data access layer. The following process will be more SQL-heavy. We will also demonstrate how you can deal with some stored CRUD procedures.

Note that EF Core also provides a way to query data sources by using stored procedures. Moreover, it exposes methods such as DbSet<TEntity>.FromSql() or DbContext.Database.ExecuteSqlCommand(). So, why use Dapper? As mentioned previously, Dapper is a micro-ORM that is simple and faster than EF Core. EF is more of a multipurpose ...