Devart Forums

Code: Select all

    using (TransactionScope transScope = new TransactionScope()) {

        using (SQLiteConnection connection1 = new SQLiteConnection(connectString1)) {
            // Opening connection1 automatically enlists it in the 
            // TransactionScope as a distributed transaction.
            connection1.Open();

            // Do work in the first connection.
        }
        using (SQLiteConnection connection2 = new SQLiteConnection(connectString2)) {
            // Open the second connection, which enlists the 
            // second connection to a full distributed transaction. 
            connection2.Open();

            // Do work in the second connection.
        }
        //  The Complete method commits the transaction.
        transScope.Complete();

        // The result of transaction will be available at the databases after
        // disposing TransactionScope
    }

Code: Select all

DAL.BeginTransaction();
var userTypes = DAL.GetUserTypes();
//
//some client work here
//
user = DAL.GetUsersForUserType(userTypes[i]);
//
//some client work here
//
DAL.UpdateUser(user);
DAL.CommitTransaction();

Code: Select all

((IObjectContextAdapter)MyDBContext).ObjectContext.Connection.BeginTransaction()
((IObjectContextAdapter)MyDBContext).ObjectContext.Connection.CommitTransaction()
and ((IObjectContextAdapter)MyDBContext).ObjectContext.Connection.RollbackTransaction()

Code: Select all

public static class DAL
{
private static TransactionScope transaction;
....
public static BeginTransaction()
{
if (transaction != null)
   transaction = new TransactionScope();
}
...
public static CommitTransaction()
{
if (transaction != null)
   try
   {
   transaction.Complete();
   }
   catch (Exception ex)
   {
   //WHAT IS HERE???
   }
   finally
   {
   transaction.Dispose();
   }
}
...
public static RollbackTransaction()
{
//IS THAT CORRECT???
if (transaction != null)
   transaction.Dispose();
}

Code: Select all

((IObjectContextAdapter)context).ObjectContext.Connection.EnlistTransaction(Transaction.Current);

Code: Select all

contextUserTypes.Database.ExecuteSqlCommand("SAVEPOINT test")

Code: Select all

contextUserTypes.Database.ExecuteSqlCommand("RELEASE test")

Code: Select all

public static void BeginTransaction()
        {            
                connectionUserTypes.Open();
                transactionUserTypes = connectionUserTypes.BeginTransaction();
                //Create a savepoint to emulate nested transaction
                contextUserTypes.Database.ExecuteSqlCommand("SAVEPOINT test");

                connectionUsers.Open();
                transactionUsers = connectionUsers.BeginTransaction();
            }
        }

Code: Select all

public static void CommitTransaction()
        {          
                try
                {
                    //commiting a savepoint (emulating commiting of a nested transaction)
                    //this makes me able to rollback upper-level transaction 
                    //if "transactionUsers.Commit()" fails
                    try
                    {
                        contextUserTypes.Database.ExecuteSqlCommand("RELEASE test");
                    }
                    catch (Exception ex)
                    {
                        //rollback a savepoint (nested transaction) 
                        contextUserTypes.Database.ExecuteSqlCommand("ROLLBACK TO test");

                        //rollback upper-level transaction 
                        transactionUserTypes.Rollback();

                        transactionUsers.Rollback();     

                        return;                
                    }

                    transactionUsers.Commit();                    

                    //the following line will never fail since I've already 
                    //successfully committed a savepoint above
                    transactionUserTypes.Commit();
                }
                //looks like "transactionUsers.Commit()" failed 
                catch (Exception ex)
                {        
                     //rollback upper-level transaction 
                     transactionUserTypes.Rollback();

                     transactionUsers.Rollback();                     
                }
                finally
                {
                    connectionUsers.Close();                    
                    connectionUserTypes.Close();
                }
        }