更新IQueryable中的行并保存更改

using System;
using System.Linq;

// 定义一个实体类
public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Email { get; set; }
}

// 创建数据库上下文类
public class MyDbContext : DbContext
{
    public DbSet<Customer> Customers { get; set; }

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

class Program
{
    static void Main(string[] args)
    {
        // 创建数据库上下文实例
        using (var context = new MyDbContext())
        {
            // 查询需要更新的数据
            IQueryable<Customer> query = context.Customers.Where(c => c.Name == "John");

            // 修改数据
            foreach (var customer in query)
            {
                customer.Email = "new_email@example.com";
            }

            // 保存更改
            context.SaveChanges();
        }
    }
}