ASP.NET Core 3 and React

Chapter 7 – Interacting with the Database with Dapper

1. What Dapper method can be used to execute a stored procedure that returns no results?

Execute

2. What Dapper method can be used to read a single record of data where the record is guaranteed to exist?

QueryFirst

3. What Dapper method can be used to read a collection of records?

Query

4. What is wrong with the following statement that calls the Dapper Query method?

return connection.Query<BuildingGetManyResponse>(  @"EXEC dbo.Building_GetMany_BySearch     @Search = @Search",   new { Criteria = "Fred"});

The query expects a parameter called Search but we have passed it a parameter called Criteria. So, Dapper won't be able to map the SQL parameter.

5. We have the following stored procedure:

CREATE ...