Questions

Answer the following questions to test the knowledge we have gained in 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 that 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 that calls the Dapper Query method:

return connection.Query<BuildingGetManyResponse>(
  "EXEC dbo.Building_GetMany...