/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

3 votes146 views2 answers
C# get dictionary first key
C#
3 votes108 views2 answers
Str::limit laravel
C#
0 vote135 views1 answer
How to get file type from base64 in c#
C#
0 vote130 views1 answer
Unity input get axis
C#Unity
0 vote119 views1 answer
Reverse Coding Challenge 1
C#
0 vote150 views1 answer
Unity error creating asset at path
C#Unity
0 vote67 views1 answer
Vb.net tostring numeric format string
C#
0 vote143 views1 answer
Get vector direction unity
C#Unity
0 vote112 views2 answers
CS0120: An object reference is required for the non-static field, method, or property 'PlayerControls.currentState'
C#
9 votes185 views3 answers
3d perlin noise unity
C#Unity