public async Task SetProductInactiveAsync(int productId)
{
using (IDbConnection con = new SqlConnection("myConnectionString"))
{
await con.ExecuteAsync("SetProductInactive", new { id = productId },
commandType: CommandType.StoredProcedure);
}
}