Razor Pages多行更新

Question

我用Index.cshtml.cs编写了以下代码(这不是MVC)

[BindProperty]
public Inventory MyInventory { get; set; }

public async Task<IActionResult> OnPostClearAllAsync()
{
   MyInventory = await _context.Inventory.FirstOrDefaultAsync(m => m.Current_State != "DEPLOYED");
   MyInventory.Verify = "0";
   _context.Attach(MyInventory).State = EntityState.Modified;
   await _context.SaveChangesAsync();
   return RedirectToPage("./Index");
}

代码运行良好，但仅适用于单行(第一次出现)。我会更新Current_State != "DEPLOYED“的所有行。请帮帮忙，谢谢。

Answer 1

我已经解决了我自己的问题，如下所示：

public async Task<IActionResult> OnPostClearAllAsync()
{
   var result = await _context.Inventory.Where(m => m.Current_State != "DEPLOYED").ToListAsync();
   foreach (var item in result)
   {
      item.Verify = "0";
      _context.Attach(item).State = EntityState.Modified;
   }
   await _context.SaveChangesAsync();
   return RedirectToPage("./Index");
}

Answer 2

最好提供更多详细信息，其中条件将贯穿所有库存上下文

public async Task<IActionResult> OnPostClearAllAsync()
{
   MyInventory = await _context.Inventory.Where(m => m.Current_State.ToLower() != 
   "deployed");
   MyInventory.Verify = "0";
   _context.Attach(MyInventory).State = EntityState.Modified;
   await _context.SaveChangesAsync();
   return RedirectToPage("./Index");
 }