Breaking News: Grepper is joining You.com. Read the official announcement!

.net core executenonqueryasync transaction

Splendid Snail answered on June 24, 2020 Popularity 3/10 Helpfulness 1/10

answer .net core executenonqueryasync transaction

.net core executenonqueryasync transaction

Comment

    var sqlQuery = "delete from table";
    using (var connection = new SqlConnection(ConnectionString))
    {
        await connection.OpenAsync();
        using (var tran = connection.BeginTransaction())
        using (var command = new SqlCommand(sqlQuery, connection, tran))
        {
            try {
                await command.ExecuteNonQueryAsync();
            } catch {
                tran.Rollback();
                throw;
            }
            tran.Commit();
        }
    }

Popularity 3/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: .net-core c#

Link to this answer
Share Copy Link