/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 vote396 views4 answers
C# string to float
C#
-1 vote354 views1 answer
Unity destroy gameobject with delay
C#
124 votes600 views6 answers
Git set origin
C#
2 votes345 views2 answers
C# csv read write
C#
0 vote339 views3 answers
How to fill model enum with bradio button asp razor
C#
0 vote363 views1 answer
??= mean C#
C#
0 vote346 views1 answer
Print the top view of the binary tree
C#
6 votes339 views1 answer
Operator -- c#
C#
0 vote333 views1 answer
Scale min max to 0 1
C#
0 vote347 views1 answer
C# create array with n elements
C#