/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

2 votes384 views1 answer
Unity default rotation
C#Unity
1 vote375 views1 answer
Unity json save array
C#
0 vote337 views1 answer
Sends keys enter selenium c#
C#
0 vote306 views1 answer
C# execute shell script
C#
1 vote333 views2 answers
C# structure
C#
-1 vote317 views1 answer
How to put double quotes in a string c#
C#
0 vote321 views2 answers
How to find the text position in excel in c#
C#
8 votes338 views2 answers
Asp.net core identity get user id
C#
0 vote352 views1 answer
C# solution path
C#
0 vote330 views1 answer
Unity if object doens't exist
C#