在Linq To SQL中更新的最佳方法

using System;
using System.Linq;
using System.Data.Linq;
using System.Data.Linq.Mapping;

[Table(Name = "Employees")]
public class Employee
{
    [Column(IsPrimaryKey = true, IsDbGenerated = true)]
    public int ID { get; set; }

    [Column]
    public string Name { get; set; }

    [Column]
    public int Age { get; set; }
}

public class DataContext : System.Data.Linq.DataContext
{
    public Table<Employee> Employees;

    public DataContext(string connectionString) : base(connectionString) { }
}

using (var db = new DataContext("your_connection_string"))
{
    // 查询要更新的员工
    var employeeToUpdate = db.Employees.Where(e => e.ID == 1).FirstOrDefault();

    // 如果找到了要更新的员工
    if (employeeToUpdate != null)
    {
        // 更新员工的属性
        employeeToUpdate.Name = "New Name";
        employeeToUpdate.Age = 30;

        // 提交更改到数据库
        db.SubmitChanges();
    }
}