Scroll to top

Dapper.NET : Using Async


Curious Bot - December 1, 2018 - 0 comments

Calling a Stored Procedure

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

Calling a stored procedure and ignoring the result

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

Related posts