/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

1 vote109 views1 answer
Unity how to move an object to another object
C#
6 votes101 views4 answers
How to set rigidbody velocity in unity
C#
1 vote58 views2 answers
C# random choice
C#
0 vote94 views1 answer
Notification platform not available c#
C#
3 votes136 views3 answers
C vs c++ vs c#
C#
0 vote96 views1 answer
Callling class c#
C#
0 vote99 views1 answer
How to convert pdfdocument to binary in c#
C#
1 vote115 views1 answer
How to pause code execution in c#
C#
0 vote92 views1 answer
How to clip out ui element if they are not inside an element unity
C#Unity
0 vote100 views2 answers
Mongodb c# batch find
C#