/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 vote112 views1 answer
How to get the current time in milliseconds .net
C#
1 vote113 views1 answer
Lat long data type c#
C#
0 vote123 views2 answers
Windows forms webbrowser navigate
C#
0 vote118 views1 answer
How to make soft body OBJECT in unity
C#
0 vote84 views1 answer
Transform face player unity
C#
0 vote148 views1 answer
How to get total scenes unity
C#Unity
-1 vote125 views2 answers
Using c#
C#
0 vote119 views1 answer
Project mongodb c#
C#
0 vote127 views1 answer
The same schemaid is already used for type swagger
C#
0 vote117 views1 answer
Even configuration custom errors page is not working asp.net MVC
C#