Using Dapper's Multi-Results Feature
Explore how to improve web API performance by using Dapper's multi-results feature to reduce database roundtrips. Learn to execute multiple queries in one call and test APIs with load testing tools for better scalability.
We'll cover the following...
We'll cover the following...
There is another feature in Dapper that helps us reduce the amount of database roundtrips called multi-results. We are going to use this feature to improve the performance of the endpoint that gets a single question, which, at the moment, is making two database calls. To do that, follow these steps:
First, let's load test the current implementation by using WebSurge. Select the “Session” tab, highlight the first request in the list, and click the “Edit” ...