/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 vote353 views1 answer
Get name of project c# .net
C#
4 votes315 views1 answer
What value of combobox index c#
C#
18 votes306 views2 answers
Unity remove all child
C#
1 vote390 views3 answers
Unity follow object
C#Unity
0 vote340 views1 answer
Remove element from sting array c#
C#
16 votes355 views6 answers
Card bootstrap 4
C#
0 vote340 views1 answer
True false when key pressed in c sharp unity
C#Unity
1 vote310 views1 answer
C# list remove duplicate items
C#
0 vote332 views1 answer
Best free Modern Design frameworks C#
C#
1 vote316 views2 answers
C# structure
C#