EF批量更新

只要前台组装好数据，想要使用ef实现批量更新是很简单的，循环改变更新转台即可

public ActionResult BatchUpdate(string jsonStr)
{
    OAEntities oaEntities = new OAEntities();
    List<UserInfo> userInfo = JsonConvert.DeserializeObject<List<UserInfo>>(jsonStr);
    foreach (UserInfo item in userInfo)
    {
        oaEntities.Entry(item).State = System.Data.EntityState.Modified;
    }
    int count = oaEntities.SaveChanges();
    return Json(count);
}

如果需要修改部分字段可以这样使用

public ActionResult BachUpdate(string jsonstr)
{
    //json反序列化
    List<Users> userList = JsonConvert.DeserializeObject<List<Users>>(jsonstr);
    oapEntities oapEntities = new oapEntities();
    foreach (Users item in userList)
    {
        oapEntities.Users.Attach(item);
        var entry = oapEntities.Entry(item);
        entry.Property("UserName").IsModified = true;//指明用户名这个字段是被修改的
        entry.Property("Number").IsModified = true;
        entry.Property("UClass").IsModified = true;
        entry.Property("CheckType").IsModified = true;
    }
    int count = oapEntities.SaveChanges();
    return Json(count);
}