/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

7 votes335 views2 answers
How to clone somthing unity
C#
18 votes300 views2 answers
Unity remove all child
C#
10 votes296 views6 answers
Remove substring from string c#
C#
0 vote324 views1 answer
C# enum variable set to nonthing
C#
0 vote310 views1 answer
Multiply structs c#
C#
0 vote323 views1 answer
Section in inspector unity
C#
11 votes306 views1 answer
Unity to integer
C#
2 votes365 views1 answer
Duolingo download
C#
0 vote313 views1 answer
Open API support for ASP.NET Core Minimal API
C#
0 vote298 views1 answer
List min and Max value in c#
C#