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();
}
}
}
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
