c#事务处理（sqlTransaction）

最新推荐文章于 2020-05-26 08:18:15 发布

weixin_30249203

最新推荐文章于 2020-05-26 08:18:15 发布

阅读量558

点赞数

文章标签： c# 数据库

原文链接：http://www.cnblogs.com/likui-bookHouse/p/9618332.html

版权

事务：

 /// <summary>
    /// 删除考勤
    /// </summary>
    /// <param name="dto">Id</param>
    /// <returns></returns>
    public ResultEntity<bool> DeleteAttend(DelAttendEditorDTO dto)
    {
        //SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;database=aaaa;uid=sa;pwd=jcx");
        //con.Open();
        using (var context = new HRModelsContainer())
        {
            var trans = context.Database.BeginTransaction();
            try
            {
                foreach (var Id in dto.Ids)
                {
                    //先删从表，再删主表
                    context.Database.ExecuteSqlCommand("DELETE FROM NoWorkDays WHERE ConfigId = @Id", new SqlParameter("@Id", Id));  
                    context.Database.ExecuteSqlCommand("DELETE FROM AttendancesConfig WHERE Id = @Id", new SqlParameter("@Id", Id));
                    context.SaveChanges();
                }
                trans.Commit();
            }
            catch (Exception error)
            {
                trans.Rollback();
                trans.Dispose();
                throw error;
            }
            finally
            {
                trans.Dispose();
            }
        }
        return GetResultEntity(true);
    }