/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 vote383 views1 answer
How to find the tag of an objecdt in unity
C#Unity
0 vote300 views1 answer
Blender how to switch cameras
C#
1 vote326 views1 answer
Access a local varible in a different function C#
C#
0 vote337 views1 answer
How to clip out ui element if they are not inside an element unity
C#Unity
9 votes333 views1 answer
Unity delete specific text in a string
C#
1 vote339 views2 answers
How to lerp in c#
C#
1 vote326 views1 answer
C# winforms textbox readonly
C#
0 vote367 views1 answer
On GAMEOBJECT enable unity
C#Unity
0 vote364 views1 answer
C# get enum value by DescriptionAttribute
C#
0 vote347 views1 answer
Reverse for loop
C#