Devart Forums

Code: Select all

 private void uxAddCountryButton_Click(object sender, EventArgs e)
        {
            TransactionOptions _TransOps = new TransactionOptions();
            _TransOps.IsolationLevel= System.Transactions.IsolationLevel.ReadCommitted;
            _TransOps.Timeout = new TimeSpan(0, 2, 0);

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, _TransOps))
            {
                try
                {
                        _TransService.InsertCountry(int.Parse(uxCountryID.Text.Trim()), uxCountryName.Text.Trim());
                        scope.Complete();
                }
                catch (FaultException tex)
                {
                    MessageBox.Show(tex.Message + "\n\r" + tex.Detail.Message + "\n\r" + tex.Detail.Details);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message + "\n\r" + ex.StackTrace);
                }
            }
        }

Code: Select all

 [ServiceBehavior(InstanceContextMode = InstanceContextMode.PerSession
                    , TransactionIsolationLevel = System.Transactions.IsolationLevel.ReadCommitted,
                    TransactionAutoCompleteOnSessionClose = false)]
    public class Service1 : IService1
    {
        string cs = "POOLING=FALSE;User Id=XXXX;Password=XXXX;Server=XXXXX;Direct=True;Sid=XXXX1;Persist Security Info=True;Transaction Scope Local=true;";

       [OperationBehavior(TransactionScopeRequired = true,   TransactionAutoComplete = false)]
        public void InsertUlke(int kod, string aciklama)
        {
            try
            {
                OracleConnection Conn = new OracleConnection(cs);
                OracleCommand comm = new OracleCommand("INSERT INTO TEST_COUNTRY (ID,DESC) VALUES (:ID,:DESC)", Conn);
                comm.Parameters.Add(":ID", OracleDbType.Number);
                comm.Parameters["ID"].Value = kod;
                comm.Parameters.Add(":DESC", OracleDbType.VarChar);
                comm.Parameters["DESC"].Value = aciklama;
                Conn.Open();
                comm.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                   throw new FaultException(new GeneralFaultException(ex), new FaultReason(ex.Message));
            }
        }

}