/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

0 vote129 views1 answer
Coroutine after another
C#
0 vote129 views1 answer
Create asp.net which send email and sms using own api
C#
1 vote132 views1 answer
Visual studio run multiple forms at once
C#
2 votes134 views2 answers
C# connect tcp
C#
2 votes133 views1 answer
Get current computer name C#
C#
0 vote169 views1 answer
How to change the width of a panel unity
C#Unity
0 vote121 views1 answer
3(x-4)-2(3x+4)=4(3-x)+5x+4
C#
0 vote131 views1 answer
C# test if char is alpha
C#
0 vote133 views1 answer
Convert object to xml c# example code
C#
1 vote147 views1 answer
Dotween sequence wait
C#