static double RunSecondLabScript() { // вывести число преподавателей по кафедрам var startTime = DateTime.Now; var teacherGroups = TeacherLogic .Read(new Teacher { PassportNumber = null }) .Join(context.Departments, t => t.DepartmentId, d => d.Id, (t, d) => new { TeacherPassportNumber = t.PassportNumber, DepartmentName = d.Name }) .GroupBy(rec => rec.DepartmentName) .ToList(); var finishTime = DateTime.Now; foreach (var group in teacherGroups) { Console.WriteLine(group.Key + " " + group.Count()); } Console.WriteLine("---Скрипт SecondLabScript выполнен"); return((finishTime - startTime).TotalMilliseconds); }
static double ReadTeachers() { var teacher = new Teacher { PassportNumber = null }; var startTime = DateTime.Now; var teachers = TeacherLogic.Read(teacher); var finishTime = DateTime.Now; foreach (var t in teachers) { Console.WriteLine($"{t.FirstName} {t.MiddleName} {t.LastName}"); } Console.WriteLine("---Скрипт ReadTeachers выполнен"); return((finishTime - startTime).TotalMilliseconds); }