/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

2 votes176 views10 answers
Test
C#
0 vote253 views1 answer
Console.out
C#
1 vote175 views2 answers
Merge xml files into one c#
C#
0 vote164 views1 answer
Aspx element visibility ould not find
C#
5 votes163 views1 answer
Unity how to get fps c#
C#
0 vote150 views1 answer
Unity mix gradient colors
C#
2 votes199 views2 answers
Linq select
C#
0 vote180 views1 answer
Email object c#
C#
0 vote173 views1 answer
Arraylist in visual studio 2015
C#
0 vote165 views1 answer
Unity Interstitial ad C#
C#