How to do database transaction in WebForms?

Question

How to do database transaction in WebForms?

Navigation

#1 by (1 votes)

1

I have an action on a .aspx file that runs multiple inserts in the database. I need that, in case something fails, the operation is canceled, since one record will depend on the other.

I usually use a transaction function to do this in other languages / frameworks (eg, PHP's Laravel).

Is it possible to do a transaction in C # / Webforms?

c# webforms

asked by anonymous 02.05.2018 / 21:37

1 answer

Why is such a simple game getting so heavy? Insert Data into PHP PDO Database

score 1 · Answer 1

The example below is using Dapper.

using (var transactionScope = new TransactionScope())
{
    using (var conexao = new SqlConnection(Configuracao.Configuracoes.StringDeConexaoSQLServer))
    {
        conexao.Open();

        sql = @"INSERT INTO  ..."; // 11
        conexao.Execute(sql, new { });
        conexao.Close();
    }

    transactionScope.Complete();
}