/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

1 vote146 views1 answer
Unity ui get the canvas
C#
0 vote147 views2 answers
Formula calculating distance coordinates latitude longitude c#
C#
1 vote141 views1 answer
How can you learn C# on your own
C#
0 vote171 views1 answer
How to authorize token when consuming api in c#
C#
1 vote182 views2 answers
Unity for loop array
C#Unity
1 vote154 views1 answer
Vector3.signedangle not showin singed angle in unity
C#
0 vote164 views1 answer
[Range(typeof(bool),"true","true",
C#
5 votes139 views2 answers
Iso date format c#
C#
1 vote150 views1 answer
Mymove() method c#
C#
0 vote139 views7 answers
Python to php converter online
C#