Topic: Read a text file and build a localDB
Problem: Read a text file and build a localDB.
Entity Framework Database First - Build an app that executes a query against the Students table of the studentGrade database.
1. Create database file (name it as studentGrade.mdf ) and insert all records in text file csvDBData.txt. You may choose to use whichever way that you like to create/populate your database file.
Note: You should add extra records in your database.
"YourLastname, YourFirstname",JR,77,4,CSCI1170,1170,A,8,4
"YourLastname, YourFirstname",JR,77,4,CSCI2170,2170,A,8,4
2. LINQ to DB - Entity Framework Database First
Your program will generate:
List of students for each class Class (FR, SO, JR, SR) ordered by GPA (large to small) then ordered by CSCI GPA.
Each student detail to be displayed should have concatenated "Course" and "FinalGrade".
For example the record to display for "Barrett, Philip"
"Barrett, Philip",JR,87,1.6664, CSCI1000 B+ CSCI1160B CSCI1170D CSCIELLED B 1910B 1920 C MATHELLED B ,8,2
Attachment:- Assignment Files.rar