/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 vote224 views1 answer
How to turn off sprite renderer in unity
C#
6 votes173 views1 answer
C# ide online
C#
0 vote222 views1 answer
Uri file path c#
C#
0 vote224 views2 answers
Create expression func c# for use in where clause
C#
0 vote232 views1 answer
Bytes to httppostedfilebase c#
C#
0 vote251 views1 answer
How to make a 2d character move in unity 2020
C#Unity
65 votes244 views6 answers
Unity reload scene
C#
0 vote205 views1 answer
C# condition and
C#
1 vote217 views1 answer
Asp.net model
C#
0 vote222 views1 answer
Force asp.net https
C#