/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 vote235 views1 answer
C# programtofindthelongestPalindromeinastring.
C#
0 vote198 views1 answer
C# datareader already open visual studio mysql
C#
0 vote176 views1 answer
Process start web document
C#
5 votes195 views4 answers
How to decrease velocity of a Unity rigidbody
C#Unity
0 vote200 views1 answer
Osk c#
C#
0 vote182 views1 answer
C# generate guid from hash
C#
-3 votes170 views1 answer
How to split a string by in c#
C#
20 votes199 views4 answers
Generate random string C#
C#
0 vote198 views1 answer
Unity enable hdr picker
C#
4 votes182 views1 answer
Shortcut to create property in c#
C#