Devart Forums

Code: Select all

using System;
using Devart.Data.Universal;
using System.Transactions;

namespace UniTransaction
{
    class Program
    {
        static void Main(string[] args)
        {
            using (TransactionScope transScope = new TransactionScope())
            {
                try
                {
                    using (UniConnection sqlConn = new UniConnection("provider=sql server;Data 

Source=xxx;Integrated Security=False;User ID=xxx; initial catalog=xxx;Enlist=true"))
                    {
                        sqlConn.Open();
                        UniCommand sqlComm = new UniCommand("update dept set dname='test' where deptno=30", 
sqlConn);
                        sqlComm.ExecuteNonQuery();
                        sqlConn.Close();
                    }

                    using (UniConnection oraConn = new UniConnection("provider=Oracle;Data 
Source=xxx;uid=xxx;pwd=xxx;Enlist=true"))
                    {
                        oraConn.Open();
                        UniCommand oraComm = new UniCommand("update dept set dname='test' where deptno=30", 
oraConn);
                        oraComm.ExecuteNonQuery();
                        oraConn.Close();
                    }
                    transScope.Complete();
                }
                catch(Exception)
                {
                    Console.WriteLine("Transaction is aborted");
                }
            }
        }
    }
}