public async Task<Product> GetProductAsync(string productId)
{
using (_db)
{
return await _db.QueryFirstOrDefaultAsync<Product>("usp_GetProduct", new { id = productId },
commandType: CommandType.StoredProcedure);
}
}