/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 vote185 views2 answers
Using (SqlDataReader sdr = cmd.ExecuteReader())
C#
18 votes195 views6 answers
C# append array
C#
0 vote236 views1 answer
Unity Rigidbody how to set zero momentum
C#Unity
34 votes175 views3 answers
Convert text to number C#
C#
0 vote175 views1 answer
StackTrace getframe last frame
C#
2 votes186 views1 answer
Convert string int Linq
C#
15 votes194 views3 answers
About unity's particle system
C#
1 vote192 views1 answer
Unity know when gameobject presed
C#Unity
2 votes180 views1 answer
Enable hibernate in windows 10
C#
5 votes185 views3 answers
C# remove first 5 characters from string
C#