Загрузка данных


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace WpfApp1
{
    public partial class MainWindow : Window
    {
        user312_dbEntities db;

        public MainWindow()
        {
            InitializeComponent();
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            Student15 student = new Student15();

            student.FirstName = txtFirst.Text;
            student.LastName = txtLast.Text;

            db.Student15.Add(student);
            db.SaveChanges();

            dgogrenci.ItemsSource = db.Student15.ToList();
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            int num = Convert.ToInt32(txtId.Text);

            var dRow = db.Student15
                .Where(w => w.ID == num)
                .FirstOrDefault();

            db.Student15.Remove(dRow);
            db.SaveChanges();

            dgogrenci.ItemsSource = db.Student15.ToList();
        }

        private void Button_Click_2(object sender, RoutedEventArgs e)
        {
            int num = Convert.ToInt32(txtId.Text);

            var uRow = db.Student15
                .Where(w => w.ID == num)
                .FirstOrDefault();

            uRow.FirstName = txtFirst.Text;
            uRow.LastName = txtLast.Text;

            db.SaveChanges();

            dgogrenci.ItemsSource = db.Student15.ToList();
        }

        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            db = new user312_dbEntities();

            dgogrenci.ItemsSource = db.Student15.ToList();
        }
    }
}
<Window x:Class="WpfApp1.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:local="clr-namespace:WpfApp1"
        mc:Ignorable="d"
        Title="WPF Entity Framework"
        Height="350"
        Width="525"
        Loaded="Window_Loaded">

    <Grid>

        <DataGrid Name="dgogrenci"
                  HorizontalAlignment="Left"
                  AutoGenerateColumns="False"
                  Height="185"
                  Margin="22,37,0,0"
                  VerticalAlignment="Top"
                  Width="246">

            <DataGrid.Columns>

                <DataGridTextColumn Binding="{Binding ID}"
                                    Header="ID"
                                    Width="*"/>

                <DataGridTextColumn Binding="{Binding FirstName}"
                                    Header="First Name"
                                    Width="3*"/>

                <DataGridTextColumn Binding="{Binding LastName}"
                                    Header="Last Name"
                                    Width="3*"/>

            </DataGrid.Columns>

        </DataGrid>

        <TextBox Name="txtId"
                 HorizontalAlignment="Left"
                 Height="23"
                 Margin="371,61,0,0"
                 TextWrapping="Wrap"
                 VerticalAlignment="Top"
                 Width="120"/>

        <TextBox Name="txtFirst"
                 HorizontalAlignment="Left"
                 Height="23"
                 Margin="371,89,0,0"
                 TextWrapping="Wrap"
                 VerticalAlignment="Top"
                 Width="120"/>

        <TextBox Name="txtLast"
                 HorizontalAlignment="Left"
                 Height="23"
                 Margin="371,117,0,0"
                 TextWrapping="Wrap"
                 VerticalAlignment="Top"
                 Width="120"/>

        <Button Content="Insert"
                HorizontalAlignment="Left"
                Margin="371,145,0,0"
                VerticalAlignment="Top"
                Width="120"
                Height="36"
                Click="Button_Click"/>

        <Button Content="Delete"
                HorizontalAlignment="Left"
                Height="36"
                Margin="371,186,0,0"
                VerticalAlignment="Top"
                Width="120"
                Click="Button_Click_1"/>

        <Button Content="Update"
                HorizontalAlignment="Left"
                Height="39"
                Margin="371,227,0,0"
                VerticalAlignment="Top"
                Width="120"
                Click="Button_Click_2"/>

        <Label Content="ID"
               HorizontalAlignment="Left"
               Margin="303,61,0,0"
               VerticalAlignment="Top"/>

        <Label Content="First Name"
               HorizontalAlignment="Left"
               Margin="300,88,0,0"
               VerticalAlignment="Top"/>

        <Label Content="Last Name"
               HorizontalAlignment="Left"
               Margin="302,117,0,0"
               VerticalAlignment="Top"/>

    </Grid>

</Window>