/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 vote144 views2 answers
Inline creation dictionnary C#
C#
4 votes133 views1 answer
Changing euler angles unity
C#
29 votes148 views3 answers
Online embedded c compiler
C#
12 votes184 views2 answers
Move towards target unity
C#Unity
0 vote146 views1 answer
Garbage collect every 30 frames unity
C#
26 votes140 views3 answers
Print in c# unity
C#
0 vote134 views1 answer
Check if palindrome recursion in c#
C#
2 votes143 views2 answers
Commenting on C#
C#
0 vote133 views1 answer
Skrivetækning
C#
2 votes134 views1 answer
Windows form rounded corners
C#