Here is an exmple of using ‘Async all the way’ using Dapper for data access in an ASP.NET Core 2.0 Razor Pages app.
Why Use Async in a Web App
If you are hitting a single database then this probably won’t speed up your app
However it will allow greater scalability of the application as the web thread won’t be locked
Simple Example using Dapper