/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

3 votes189 views1 answer
How to move your character in unity 2d game
C#Unity
0 vote135 views1 answer
Unity banner ad C#
C#
0 vote137 views1 answer
Asp net mvc 5 return view from another controller
C#
0 vote150 views1 answer
C# double without exponential notation
C#
0 vote138 views1 answer
You are trying to create a MonoBehaviour using the 'new' keyword.
C#
1 vote141 views1 answer
How to get a variable from another script c#
C#
0 vote133 views1 answer
Reference variable from another script "winforms" c#
C#
1 vote154 views1 answer
C# cast to type variable
C#
29 votes135 views2 answers
Car
C#
0 vote148 views1 answer
Gridview edit update delete in asp.net textbox size
C#