ef 修改数据

来源：互联网发布：富士施乐mac驱动编辑：程序博客网时间：2024/05/17 20:30

单条修改

SY_company SYC = EF.SY_company.Where(a => a.ID == id).SingleOrDefault();
                        if (SYC != null)
                        {
                           SYC .Name = cm.Name;
                           SYC .Address = cm.Address;
                           SYC .ZipCode = cm.ZipCode;
                           SYC .Province_ID = cm.Province_ID;
                          SYC .City_ID = cm.City_ID;
                           SYC .UpdateTime = DateTime.Now;
                          SYC .UpdateUser_id = UserInfo.UserID;
                            EF.SaveChanges();
                        }

批量一起修改

var SY_Update = db.SCYX_YJGL.Where(a => a.TITLE == TextField_WDMC.Text);
                    foreach (var c in SY_Update)
                    {
                        c.FILE_NAME = FileName;
                        c.FILE_WEBURL = WebFilePathName;
                    }

db.SaveChanges();

0 0