Devart Forums

Code: Select all

 public void DoRequiredScope()
        {
            try
            {
                TransactionOptions transOptions = new TransactionOptions();
                transOptions.IsolationLevel = IsolationLevel.ReadCommitted;
                transOptions.Timeout = new TimeSpan(0, 0, 30);

                using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, transOptions))
                {
                    Debug.WriteLine("Current Transaction is " + Transaction.Current.TransactionInformation.LocalIdentifier);
                    Transaction.Current.TransactionCompleted += Current_TransactionCompleted;
                 

                    using (Entities entities = new Entities())
                    {
                        entities.Connection.Open();
                        PERSON app = entities.PERSON.First();
                        app.FIRSTNAME = "A Change w/txn";
                        Console.WriteLine(app.FIRSTNAME);
                        entities.SaveChanges();
                        entities.Connection.Close();
                        
                    }
                    ts.Complete();
                }
                    
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
                //throw;
            }
        }

        public void DoNoTransaction()
        {
            try
            {
                using (Entities entities = new Entities())
                {
                    entities.Connection.Open();
                    PERSON app = entities.PERSON.First();
                    app.FIRSTNAME = "A Change w/o txn";
                    Console.WriteLine(app.FIRSTNAME);
                    entities.SaveChanges();
                    entities.Connection.Close();
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
                Debug.WriteLine(ex.StackTrace);
            }
        }