/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

6 votes235 views3 answers
Disable rigidbody unity
C#
0 vote241 views1 answer
If file exist rename c#
C#
5 votes251 views3 answers
List search c#
C#
0 vote266 views1 answer
How to instantiate more enemies in unity
C#Unity
2 votes676 views1 answer
Unity c# addition class
C#
13 votes290 views3 answers
Print random number unity
C#Unity
2 votes268 views3 answers
Unity always rotating object
C#Unity
0 vote230 views1 answer
Linq query languages
C#
5 votes250 views2 answers
Unity hide in inspector
C#
1 vote213 views1 answer
Disable button in android studio
C#