/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 vote100 views2 answers
Get first and last item list c#
C#
0 vote101 views1 answer
C# print all property values of object
C#
3 votes90 views1 answer
How to load the active scene unity
C#
2 votes104 views2 answers
String to list c#
C#
1 vote105 views1 answer
C# list remove duplicate items
C#
0 vote103 views1 answer
Sum the digits in c#
C#
0 vote109 views1 answer
C# save pdf to folder
C#
3 votes96 views2 answers
C# Select MSSQL
C#
7 votes123 views3 answers
C# repeat x times
C#
0 vote136 views1 answer
Get parent name unity for inspector
C#Unity