Create a database application using Entity Framework Core, a data access technology for a student application.

Create a database application using Entity Framework Core, a data access technology for a student application.

This is a Code First approach that creates an entity Class in your application from table (Student) in the database.

The application must show records of the data in a data grid view if any. The details for any record will only display by typing the StudentID number in a textbox to display the information that the student is looking for.

Your screen should be like what is shown in Figure 7.0 below with a product, where the “Get Product” button is clicked to the Product Code. However, in your case, you will be retrieving a student record by searching for the student ID. Add buttons to “Add”, “Modify”, and “Delete” the record of the student that is displayed. Add a “Clear” button to clear the screen and add an “Exit” button to close the application.

You may use your own discretion on how you want your screen to look like. However, all the functionalities mentioned in the application must be observed.

  Exercise-7
Create a WinForm application with the following properties for “Student”
table:
Column
Data Type
Notes
StudentID
int
Primary Key
FirstName
string
Maximum of 30 characters
LastName
string
Maximum of 30 characters.
DoB
Date
Entering time must not be allowed on the page
Major
string
Maximum of 30 characters
Note: After creating Student table in your database, you may start your using Windows
Forms App template. DO NOT USE Windows Forms App (.NET Framework)!
•
Then, prepare your application to use Entity Framework Core
•
Create a database application using Entity Framework Core, a data access
technology for a student application.
•
This is a Database First approach that creates an entity Class in your application
from a table (Student) in the database.
•
The application must show records of the data in a data grid view if any. The
details for any record will only be displayed by typing the StudentID number in a
textbox to display the information that the student is looking for.
•
Your screen should be like what is shown in Figure 7.0 below with a product,
where the “Get Product” button is clicked to the Product Code. However, in your
case, you will be retrieving a student record by searching for the student ID. Add
buttons to “Add”, “Modify”, and “Delete” the record of the student that is
displayed. Add a “Clear” button to clear the screen and add an “Exit” button to
close the application.
•
You may use your own discretion on how you want your screen to look like.
However, all the functionalities mentioned in the application must be observed.
Name: Joemar Deypalubos
To submit your work, you will submit 2 files for Exericse 7 as shown below:
1. Submit your work to the Blackboard as shown here: Zip your solution folder and
save as LastName + Initial of FirstName + “_” + Exercise-7.zip. For example,
if your name is John Doe, then, your zipped file (that you will upload) will look
thus: DoeJ_Exercise-2.zip.Your adherence to the above format is greatly
appreciated. Please use this format for all exercises in this class, while
substituting each exercise (1, 2, …) accordingly.
2. A generated script of your database file that contains the structure of your table
and the data in it. Your instructor will do a demo on how to do this. Then, you will
name the file thus: LastNameLastName + Initial of FirstName + “_” +
Ex7SQL.sql