Introduction
This article show how to select data using entity framework in WPF application.
Create wpf application as in figure 1
Figure 1: Create wpf application
Add entity framework to project as in figure 2, 3, 4, 5, 6 and 7
Figure 2: Add entity framework
Figure 3: Entity data model wizard
Figure 4: Choose connection
Figure 5: Choose entity framework version
Figure 6: Choose database object
Figure 7: Model designer
MainWindow.xaml
<Window x:Class="SelectData_WPF_EFApp.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="MainWindow" Width="735.448" Height="350" Loaded="Window_Loaded"> <DataGrid x:Name="dgEmployee" Width="221" Margin="242,47,0,0" HorizontalAlignment="Left" VerticalAlignment="Top" AutoGenerateColumns="False" CanUserAddRows="False" ColumnWidth="*"> <DataGrid.Columns> <DataGridTextColumn x:Name="dgrEmpId" Binding="{Binding EmpId}" Header="EmpId" IsReadOnly="True" /> <DataGridTextColumn x:Name="dgrFirstName" Binding="{Binding FirstName}" Header="FirstName" IsReadOnly="True" /> <DataGridTextColumn x:Name="dgrLastName" Binding="{Binding LastName}" Header="LastName" IsReadOnly="True" /> </DataGrid.Columns> </DataGrid> </Window>
MainWindow.xaml.cs
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 SelectData_WPF_EFApp { /// <summary> /// Interaction logic for MainWindow.xaml /// </summary> public partial class MainWindow : Window { public MainWindow() { InitializeComponent(); } private void Window_Loaded(object sender, RoutedEventArgs e) { dgEmployee.ItemsSource = objEmployeeEntities.Employees.ToList(); } EmployeeDBEntities objEmployeeEntities = new EmployeeDBEntities(); } }
Output of the application as in the following as in figure 8
Figure 8: Output of the application
Summary
In this article we saw how to select data using entity framework in WPF application.