/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

40 votes294 views5 answers
C# foreach dictionary
C#
8 votes291 views1 answer
Unity how to convert mouse screen position to world position
C#
54 votes293 views6 answers
Top most wishlisted games on steam
C#
3 votes287 views1 answer
C# public 2d array
C#
0 vote279 views1 answer
C# changimg to one decimal place
C#
0 vote313 views1 answer
Dotnet DB context register
C#
-1 vote277 views1 answer
Build a project from dotnet using cli
C#
0 vote291 views1 answer
C# button click gets assigned the last value
C#
2 votes304 views1 answer
How to run a function as administrator in c#
C#
0 vote306 views1 answer
??= mean C#
C#