/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 vote225 views1 answer
C# get classes which inherits
C#
1 vote257 views1 answer
C# get next item in list
C#
10 votes242 views1 answer
Unity c# get bool from another script
C#
0 vote235 views1 answer
Get directory name of path c#
C#
0 vote240 views1 answer
C# insert spaces before capital letters
C#
1 vote260 views1 answer
C# unity change key input in inspector
C#Unity
0 vote239 views1 answer
Getelement video
C#
-1 vote227 views1 answer
What does -> in f#?
C#
0 vote246 views1 answer
Sorting c#
C#
4 votes286 views1 answer
Unity replace a text in a string
C#