EntityFramework 入门（二）

EntityFramework 常用的增删改查

1.添加数据

 var s = new Happening()
            {
                ID = strID,
                Name = happening.Name,
                PublishDate = happening.PublishDate,
                EndDate = happening.EndDate,
                CreatedDate = DateTime.Now,
                CreatedBy = userName,
                LastModifiedDate = DateTime.Now,
                LastModifiedBy = userName
            };
 _applicationDbContext.Happening.Add(s);
_applicationDbContext.SaveChanges();

2.修改数据

  var happen = _applicationDbContext.Happening.FirstOrDefault(s => s.ID == happening.ID && s.IsDeleted == false);

            happen.Name = happening.Name;
            happen.IsEnabled = happening.IsEnabled;
            happen.PublishDate = happening.PublishDate;
            happen.EndDate = happening.EndDate;
            happen.Seq = happening.Seq;
            happen.LastModifiedBy = userName;
            happen.LastModifiedDate = DateTime.Now;

_applicationDbContext.SaveChanges();

批量修改

  foreach (var more in _applicationDbContext.HappeningMorePost.Where(u => u.HappeningID == happening.ID).ToList())
  {
      more.IsDeleted = true;
      more.LastModifiedBy = userName;
      more.LastModifiedDate = DateTime.Now;
  }

3.删除数据

 var appversion = _applicationDbContext.Happening.FirstOrDefault(s => s.ID == id && s.IsDeleted == false); 
 _applicationDbContext.Happening.Remove(appversion);
 _applicationDbContext.SaveChanges()

批量删除