
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(); // 提交事务
tran.Commit();
} catch (Exception ex)
{ if (tran != null)
{ // 事务回滚
tran.Rollback();
Console.WriteLine("事务回滚"); throw ex;
}
} finally { if (entity != null && entity.Connection.State != ConnectionState.Closed)
{
entity.Connection.Close();
}
}
}
