Razor Pages多行更新

Question

我在Index.chtml.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！=的所有行"展开"；。请帮忙，谢谢你。

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");
}