Devart Forums

Code: Select all

using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew))
            {
                MySqlConnection cn = new MySqlConnection();
                cn.ConnectionString = connectionString;
                cn.Open();
                MySqlCommand c = new MySqlCommand("INSERT INTO operateur.privileges(alias) VALUES('plop')", cn);
                c.ExecuteNonQuery();
                MySqlCommand c2 = new MySqlCommand("INSERT INTO operateur.privileges(alias) VALUES('plop2')", cn);
                c2.ExecuteNonQuery();
                t.Complete();
            }