/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 vote131 views1 answer
Polling data source c# using threads
C#
0 vote118 views1 answer
How-to-add-new-column-with-value-to-the-existing-datatable
C#
1 vote130 views1 answer
C# cast to type variable
C#
2 votes168 views1 answer
How to check the tag of a collider in unity
C#Unity
0 vote158 views1 answer
How to authorize token when consuming api in c#
C#
3 votes102 views2 answers
C# app path
C#
43 votes71 views2 answers
How to change the scale of an object in unity
C#
1 vote120 views1 answer
Select a object from list based on a value csharp
C#
0 vote116 views1 answer
How to center a window in monogame
C#
6 votes110 views6 answers
Rigidbody velocity
C#