千家信息网

Entity Framework 的事务 DbTransaction

发表于:2025-02-02 作者:千家信息网编辑
千家信息网最后更新 2025年02月02日,public static void Transaction(){ myitEntities entity = null; DbTransaction tran = null; tr
千家信息网最后更新 2025年02月02日Entity Framework 的事务 DbTransaction

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();    }    }}


0