实体框架核心如何使用foreach()？

public class Student
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

public class SchoolContext : DbContext
{
    public DbSet<Student> Students { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("YourConnectionStringHere");
    }
}

using (var context = new SchoolContext())
{
    var students = context.Students.ToList(); // 先将查询结果加载到内存中

    foreach (var student in students)
    {
        Console.WriteLine($"Student ID: {student.Id}, Name: {student.Name}, Age: {student.Age}");
    }
}

using (var context = new SchoolContext())
{
    var studentsToUpdate = new List<Student>();

    foreach (var student in context.Students.ToList())
    {
        if (student.Age < 18)
        {
            student.Age = 18; // 假设我们要将未成年学生的年龄更新为18
            studentsToUpdate.Add(student);
        }
    }

    context.SaveChanges(); // 在遍历结束后一次性保存所有更改
}