/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

9 votes226 views1 answer
Unity get layer of gameobject
C#Unity
0 vote203 views1 answer
Asp.net core api Self referencing loop detected for property
C#
3 votes219 views3 answers
Rigidbody2d unity
C#Unity
0 vote175 views1 answer
C# on variable change property get set
C#
4 votes129 views3 answers
How to use onmousedown unity
C#
1 vote171 views1 answer
C# convert seconds to hours minutes seconds
C#
0 vote170 views1 answer
Remove header visual studio android
C#
0 vote185 views1 answer
Limiting the amount of decimal places c#
C#
1 vote185 views1 answer
Unity closest point to line
C#Unity
0 vote128 views1 answer
Radiobutton in asp.net
C#