在asp.net MVC6中使用实体框架更新foreach循环中的数据库记录

using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using System.Linq;

public class MyController : Controller
{
    private readonly MyDbContext _dbContext;

    public MyController(MyDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    public IActionResult UpdateRecords()
    {
        // 获取需要更新的记录集合
        var records = _dbContext.MyRecords.ToList();

        foreach (var record in records)
        {
            // 修改记录的属性值
            record.Property1 = "New Value 1";
            record.Property2 = "New Value 2";

            // 更新记录
            _dbContext.Entry(record).State = EntityState.Modified;
        }

        // 保存修改到数据库
        _dbContext.SaveChanges();

        return RedirectToAction("Index");
    }
}