/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 vote201 views1 answer
Chrome devtools capture all styling an element uses
C#
0 vote226 views1 answer
Unity read from text file
C#
0 vote197 views1 answer
C# webclient submit form
C#
0 vote187 views1 answer
Query parameters sending to controller action asp.net core
C#
0 vote232 views1 answer
Adding to a dictionary unity
C#
0 vote220 views1 answer
C# read xml tag value
C#
0 vote188 views1 answer
Gridview edit update delete in asp.net textbox size
C#
0 vote193 views1 answer
C# quaternion eular calculator
C#
4 votes205 views3 answers
How to create a singleton in unity
C#
0 vote187 views1 answer
Asp.net core update-database specify environment
C#