删除

单个删除

var users = await _context.Users.Where(u => u.iStatus == 0).ToListAsync();
_context.Users.RemoveRange(users);
await _context.SaveChangesAsync();

批量删除

// 删除所有 iStatus == 0 的用户
await _context.Users
    .Where(u => u.iStatus == 0 &&  id.Contains(u.id))
    .ExecuteDeleteAsync();

修改

单个修改

var user = await _context.Users.FindAsync(id);
if (user != null)
{
    user.Name = "新名字";
    user.iStatus = 1;
    await _context.SaveChangesAsync();
}

批量修改

await _context.Users
    .Where(u => u.iStatus == 0 &&  id.Contains(u.id))
    .ExecuteUpdateAsync(setters => setters
        .SetProperty(u => u.iStatus, 1)
        .SetProperty(u => u.update_time, DateTime.UtcNow)
    );