Answers

1. Execute is the Dapper method that executes a stored procedure, returning no results.
2. QueryFirst is the Dapper method for reading a single record of data where the record is guaranteed to exist.
3. Query is the Dapper method for reading a collection of records.
4. The problem with the query is that it 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. The problem is that the stored procedure returns a field called BuildingId, which won't automatically get mapped to the Id property in the class because the names are different.
6. Yes! DbUp can execute any SQL script, and can also deploy new reference data for a table.