/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 vote121 views1 answer
C# create default instance of type
C#
0 vote120 views1 answer
How to display array in string in c#
C#
0 vote73 views1 answer
Radiobutton in asp.net
C#
0 vote130 views1 answer
C# video to frames
C#
2 votes155 views1 answer
Set player position unity
C#Unity
0 vote118 views1 answer
C# name script
C#
0 vote115 views1 answer
How to write a ello world program in c#
C#
0 vote118 views1 answer
Remove loading bars devexpress on callback
C#
4 votes114 views2 answers
C# Escape sequence
C#
1 vote164 views1 answer
Unity rigid body variable
C#Unity