/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 vote306 views1 answer
C# int array length
C#
0 vote346 views1 answer
C# mysql select into datatable
C#
0 vote324 views1 answer
Replace first occurrence of character in string c#
C#
1 vote317 views1 answer
C# xpath read attribute value
C#
0 vote342 views1 answer
Exception handling in c# web api
C#
0 vote336 views1 answer
Rotate along normal unity
C#
1 vote385 views1 answer
Get all devices connected using player input manager unity
C#Unity
1.1K votes564 views10 answers
Twitch
C#
0 vote382 views1 answer
Length of array c# unity
C#Unity
1 vote317 views1 answer
Csharp get integer part of number
C#