/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

0 vote272 views1 answer
How to resize a panel unity
C#
0 vote255 views1 answer
Blazor alert
C#
0 vote290 views1 answer
Unity get game version
C#Unity
0 vote249 views1 answer
Hacker typer.com
C#
0 vote329 views1 answer
Convert word files to plain text c#
C#
24 votes267 views7 answers
Qwertyuiopasdfghjklzxcvbnm
C#
0 vote215 views1 answer
Visibility bound to radio button wpf
C#
0 vote256 views1 answer
Combined 2 arrays
C#
0 vote275 views1 answer
Async method out parameter c#
C#
3 votes245 views2 answers
C# app path
C#