.NET Summer 2020 (external)

Task07. LINQ

Task

• Supplement the database developed in Task06 with information about the specialty for each group and the full name of the examiner for each test and exam.
• Implement CRUD using LINQ-to-SQL.
• Supplement the reports with information about the average mark for a single session each specialty, the average mark for each examiner.
• Within display the dynamics of changes in the average mark for all sessions as a table each subject by year.
• When generating reports, provide for the possibility of various sorts.
• Develop unit tests for testing created classes.
• Develop SQL scripts for rapid deployment and filling in DBMS data.