of 2 Automatic Zoom Actual Size Page Fit Page Width 50% 75% 100% 125% 150% 200% 300% 400% Lab #4 – WPF + Entity Framework Core
Due Date: Midnight of April 01 (Friday)
Purpose: Become familiar with WPF and Entity Framework Core.
- Learn to create advanced GUI.
Instructions: Be sure to read the following general instructions carefully:
This assignment should be completed individually by all the students. You are encouraged to
demonstrate your solution during lab session and submit your solution through the drobox. You
must name your submission according to the following rule:
studentID(yourlastname)_ASSnumber.zip. e.g., 300123456(smith)_ASS#4.zip
Rubric
Question 1
Functionality Marks
WPF GUI (XAML) 3
Generate data model 2
Data Binding 2
Functionality – data manipulation 2
Overall (code readability, app usability, etc.) 1
Question 1 [10 marks]
1. Create a Customer.mdf database as per diagram below. Populate the database with 4
records.
2. Build a WPF that populates and modify the records in the database (Add records, Find
Records (as per CustomerID), Edit Records, Delete Records).
3. Create buttons to displays the results of the following queries:
3.1. Generate a report with all the Customers and their Addresses.
3.2. Sort the results by Customers First Name.
3.3. Get a list of all the Customers from Canada.
3.4. Sort the results by Company Name.