如何在WPF中使用Datagrid更新数据库

// 数据模型类
public class Person : INotifyPropertyChanged
{
    private int id;
    private string name;
    private int age;

    public int Id
    {
        get { return id; }
        set { id = value; OnPropertyChanged(nameof(Id)); }
    }

    public string Name
    {
        get { return name; }
        set { name = value; OnPropertyChanged(nameof(Name)); }
    }

    public int Age
    {
        get { return age; }
        set { age = value; OnPropertyChanged(nameof(Age)); }
    }

    public event PropertyChangedEventHandler PropertyChanged;

    protected virtual void OnPropertyChanged(string propertyName)
    {
        PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));
    }
}

// XAML文件中的DataGrid控件
<DataGrid x:Name="dataGrid" AutoGenerateColumns="False" ItemsSource="{Binding Persons}">
    <DataGrid.Columns>
        <DataGridTextColumn Header="ID" Binding="{Binding Id}" />
        <DataGridTextColumn Header="Name" Binding="{Binding Name}" />
        <DataGridTextColumn Header="Age" Binding="{Binding Age}" />
    </DataGrid.Columns>
</DataGrid>

// 代码中的数据库连接和数据操作
public partial class MainWindow : Window
{
    private ObservableCollection<Person> persons;

    public ObservableCollection<Person> Persons
    {
        get { return persons; }
        set { persons = value; }
    }

    public MainWindow()
    {
        InitializeComponent();
        DataContext = this;

        // 建立数据库连接，查询数据并绑定到DataGrid
        using (var context = new MyDbContext())
        {
            Persons = new ObservableCollection<Person>(context.Persons.ToList());
        }
    }

    private void dataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
    {
        // 获取修改后的数据
        var editedPerson = e.Row.Item as Person;

        // 更新数据库中的数据
        using (var context = new MyDbContext())
        {
            if (editedPerson.Id == 0)
            {
                // 添加新数据
                context.Persons.Add(editedPerson);
            }
            else
            {
                // 更新已有数据
                var person = context.Persons.Find(editedPerson.Id);
                if (person != null)
                {
                    person.Name = editedPerson.Name;
                    person.Age = editedPerson.Age;
                }
            }

            context.SaveChanges();
        }
    }
}