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

Finding the right tool for the job

EF Core and Dapper provide an abstraction level over our data source. Nevertheless, both of them have some pros and cons. It is essential to bear in mind that, for every project we are working on, we should seek to find the right tool for the job.

Let's analyze some pros and cons for these two libraries. Before that, we should take a quick look at some demo queries in order to understand the differences between the two. The following snippet describes a sample query using EF Core:

using (var context = new CatalogContext()) {     var items = context.Items                                 .Where(b => b.Description.Contains("various                          artists"))                        .ToList();}

In the preceding code, we search for every Item entity with a corresponding description. ...