/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 vote199 views1 answer
Recursive reverse linked list
C#
0 vote248 views1 answer
LINQ query on a DataTable C#
C#
1 vote201 views1 answer
C# find start and end of month from object date
C#
0 vote185 views2 answers
C# list remove by index
C#
0 vote203 views1 answer
Unity how to set framrate C#
C#
0 vote223 views2 answers
How to get src value from img tag in c#
C#
0 vote239 views1 answer
Jarray to list c#
C#
0 vote213 views1 answer
Set custom default file in startup
C#
11 votes242 views3 answers
C# return two values
C#
1 vote207 views2 answers
C# environment variables
C#