Questions

Answer the following questions to test the knowledge you have gained from this chapter:

1. What Dapper method can be used to execute a stored procedure that returns no results?
2. What Dapper method can be used to read a single record of data, where the record is guaranteed to exist?
3. What Dapper method can be used to read a collection of records?
4. What is wrong with the following statement, which calls the Dapper Query method?

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

5. We have the following stored procedure:

   CREATE PROC dbo.Building_GetMany 
   AS
   BEGIN
     SET NOCOUNT ON
     SELECT BuildingId, Name 
     FROM dbo.Building 
   END

   We have the following statement, which calls the Dapper Query method:

   return connection.Query<BuildingGetManyResponse&gt...