/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

6 votes258 views3 answers
C# convert timestamp to datetime
C#
0 vote246 views1 answer
How to auto format c# code in visual studio
C#
1 vote258 views1 answer
Exit application wpf
C#
20 votes250 views4 answers
How to change scenes in unity
C#
6 votes644 views3 answers
Dynamically add rows to datagridview c#
C#
0 vote268 views1 answer
Dirty property unity
C#
0 vote250 views1 answer
C# Program For Check Total Occurrence Of A Number In An Array
C#
9 votes240 views2 answers
How to access gameobject name
C#
-2 votes266 views1 answer
Get selected rows gridcontrol devexpress
C#
-1 vote237 views1 answer
Change text color wpf
C#