Linq to sql 添加,修改,删除,事务操作

添加记录

using (TransactionScope Tan = new TransactionScope()) //事务操作,当添加出错时就会回滚,在多操作时使用大
            {

                   DirectoryTree obj = new DirectoryTree();//dbml 对象
                   obj.ParentID = Convert.ToInt32(HiddenField1.Value.Replace("Add", "").Trim());
                   obj.Description = x.Count() == 0 ? "属性1" : string.IsNullOrEmpty(x.First().p) ? "属性1" : "属性" + (x.Count() + 1).ToString();
                   obj.CreatedBy = "fei";
                   obj.ModifyBy = "fei";
                   obj.ModifyDate = System.DateTime.Now;
                   obj.RDate = System.DateTime.Now;
                   obj.Remarks = "测试物料";
                   DataContext.DirectoryTrees.InsertOnSubmit(obj);
                   DataContext.SubmitChanges();

                 Tan.Complete();

            }

删除记录

using (TransactionScope Tan = new TransactionScope()) //事务操作,当添加出错时就会回滚,在多操作时使用大
            {

                   var delx = from s in DataContext.DirectoryTrees where ID.Contains(s.ID) select s;
                   if (delx.Count() > 0)
                   {
                       foreach (var n in delx)
                       {
                           DataContext.DirectoryTrees.DeleteOnSubmit(n);
                           DataContext.SubmitChanges();
                       }                  
                   }

           Tan.Complete();

            }

 

修改记录

using (TransactionScope Tan = new TransactionScope()) //事务操作,当添加出错时就会回滚,在多操作时使用大
            {

            var n = from x in DataContext.DirectoryTrees where x.ID == Convert.ToInt32(Request["key"]) select x;
            foreach (var j in n)
            {
                j.ModifyBy ="000";
                j.ModifyDate = System.DateTime.Now;
                j.Remarks =string.IsNullOrEmpty(Request["Remarks"])?"":Server.UrlDecode(Convert.ToString(Request["Remarks"]));
                j.Description = string.IsNullOrEmpty(Request["Description"]) ? "" : Server.UrlDecode(Convert.ToString(Request["Description"]));  
               
            }
            DataContext.SubmitChanges();

            Tan.Complete();

            }

http://blog.csdn.net/gentle_wolf/article/details/2695109