/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 vote138 views2 answers
How to update modal class using dbfirst in asp.net core
C#
0 vote136 views1 answer
C# random hash
C#
1 vote125 views1 answer
If number negative c sharp
C#
0 vote114 views1 answer
Rock paper scissors c#
C#
0 vote124 views1 answer
WebClient timeout
C#
0 vote144 views1 answer
How to add rigidbody as a variable
C#
0 vote142 views1 answer
C# same folder path
C#
-1 vote129 views1 answer
Unity move character with animation
C#
0 vote132 views1 answer
Create dropdown in datatable c# dynamically
C#
0 vote121 views2 answers
Convert text to ssml function
C#