/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 vote232 views2 answers
C# list sort by property string
C#
1 vote197 views1 answer
Unity c# struct
C#
0 vote200 views1 answer
C# remove non-alphanumeric characters from string
C#
0 vote216 views1 answer
SqldataReader get row count
C#
9 votes203 views2 answers
How to convert float to int c#
C#
4 votes184 views1 answer
How to stop window from terminating c# visual studio
C#
4 votes192 views1 answer
C# get user directory
C#
18 votes203 views3 answers
Get random from list c#
C#
1 vote198 views1 answer
Disable button in android studio
C#
0 vote231 views2 answers
Unity screentoworldpoint
C#Unity