Transaction DbTransaction of Entity Framework
Public static void Transaction () {myitEntities entity = null; DbTransaction tran = null; try {entity = new myitEntities (); entity.Connection.Open (); tran = entity.Connection.BeginTransaction (); Student st = entity.Student.FirstOrDefault (c = > c.StudentID = = 20); st.StudentName = "test"; st.Age = 55; entity.SaveChanges (); / / commit transaction tran.Commit () } catch (Exception ex) {if (tran! = null) {/ / transaction rollback tran.Rollback (); Console.WriteLine ("transaction rollback"); throw ex;}} finally {if (entity! = null & & entity.Connection.State! = ConnectionState.Closed) {entity.Connection.Close ();}
