title: Entity transaction not working
body: <p>I am using entity transaction in my project but somehow it is not working.
  It is also not giving any error. Pls help me.
  I am giving some code ...</p>
  
  <pre><code>EntityConnection objEntityCon = new EntityConnection(CommonDividentBL.GetEntityConnectionString());
      objEntityCon.Open();
      // Begin Transaction
      EntityTransaction entityTransaction = objEntityCon.BeginTransaction();
      try
      {
          //database saving code
  
          entityTransaction.Commit();
          objEntityCon.Close();
      }
      catch (Exception ex)
      {
          entityTransaction.Rollback();
      }
  </code></pre>