/C#/.net core executenonqueryasync transaction

.net core executenonqueryasync transaction

    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();
        }
    }

Source: stackoverflow.com

Similar codes

11 votes199 views2 answers
C# random choice
C#
5 votes165 views3 answers
C# merge two lists with return
C#
0 vote162 views2 answers
Component dynamic vue
C#
6 votes184 views3 answers
C# return switch
C#
8 votes158 views2 answers
C# assign if null
C#
0 vote180 views1 answer
Bitwise Left Shift C#
C#
3 votes191 views2 answers
C# console play sound
C#
0 vote208 views1 answer
Unity quit in edtor
C#Unity
0 vote179 views1 answer
C# lambda join two tables
C#
5 votes177 views2 answers
C# how to run external program
C#