/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 vote144 views2 answers
How to sort a dictionary by value in c#
C#
0 vote176 views1 answer
CamelCase and snakeCase
C#
0 vote148 views1 answer
Wpf binding object get value
C#
2 votes171 views2 answers
C# main file
C#
1 vote203 views1 answer
Unity c# check if multiple keys are pressed
C#
1 vote130 views1 answer
Data annotation c# name
C#
0 vote158 views1 answer
C# string to enum conversion
C#
0 vote158 views1 answer
Validating file upload asp.net core mvc
C#
1 vote152 views1 answer
C# check if 2d array position exists
C#
0 vote153 views1 answer
How to store user input into list c#
C#