/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 vote98 views1 answer
How to go from one form to another in c# windows application
C#
1 vote120 views2 answers
How to get hours and minutes from second in c#
C#
0 vote133 views1 answer
C# console create window
C#
0 vote134 views1 answer
Access object property C#
C#
8 votes119 views2 answers
Float to int c#
C#
1 vote157 views1 answer
Unity agent bake not derecting mesh
C#
0 vote137 views1 answer
Taskcontinuationoptions.onlyonfaulted
C#
0 vote140 views1 answer
C# how to start an application and detect if started
C#
1 vote131 views1 answer
Iterate through xpdictionary devexpress
C#
0 vote125 views1 answer
Mongodb driver c# nuget
C#