예제 #1
0
        static void StudentAssignment()
        {
            DBContextFile db = new DBContextFile();
            //Student[] students
            int totalStudents = db.Students.Count();

            Student[] students   = db.Students.ToArray();
            double    averageSat = students.Average(s => s.SAT);
            decimal   averageGPA = students.Average(s => s.GPA);

            Student[] studentsGraduated = db.Students
                                          .Where(s => s.GradYear < DateTime.Today.Year)
                                          .OrderBy(s => s.GradYear)
                                          .ToArray();

            Student[] studentsWithHigherSat = students.Where(s => s.SAT > averageSat).OrderByDescending(s => s.SAT).ToArray();

            WriteLine($"Total Students: {totalStudents}");
            foreach (var s in students)
            {
                WriteLine($"Id: {s.Id}, Name: {s.Name}, Major: { s.Major}, GradYr: {s.GradYear}, Honors: {s.GradWithHonors}, Donor: {s.AlumniDoner}, SAT: {s.SAT}, GPA {s.GPA}");
            }

            WriteLine($"\nGraduated Students");
            foreach (var s in studentsGraduated)
            {
                WriteLine($"Name: {s.Name} {s.GradYear}");
            }
            WriteLine($"\nAverage Student GPA: {averageGPA}");
            WriteLine($"Average SAT: {averageSat}");
            WriteLine($"\nStudents with 'Greater than Average SAT ({averageSat})");
            foreach (var s in studentsWithHigherSat)
            {
                WriteLine($"Name: {s.Name}, SAT: {s.SAT}");
            }
        }
예제 #2
0
        static void TestAssignment()
        {
            DBContextFile db = new DBContextFile();

            Test[] tests = db.Tests.ToArray();
        }