protected internal static void SqlQueries() { Console.Clear(); Console.WriteLine("Choose Action: "); Console.WriteLine("1) Select * From Students."); Console.WriteLine("2) Select * From Trainers."); Console.WriteLine("3) Select * From Assignments."); Console.WriteLine("4) Select * From Courses."); Console.WriteLine("5) Students Per Course."); Console.WriteLine("6) Trainers Per Course."); Console.WriteLine("7) Assignment Per Course."); Console.WriteLine("8) Assignment Per Course Per Student."); Console.WriteLine("9) Students that belong to more than one course."); Console.WriteLine("Press any other key to return to Main menu."); ConsoleKeyInfo menuSelection; menuSelection = Console.ReadKey(true); SQL_Utils sQL_Utils = new SQL_Utils(); switch (menuSelection.KeyChar) { case '1': Console.Clear(); Console.WriteLine("Select * From Students.\n"); sQL_Utils.SelectStudent(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; case '2': Console.Clear(); Console.WriteLine("Select * From Trainers.\n"); sQL_Utils.SelectTrainer(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; case '3': Console.Clear(); Console.WriteLine("Select * From Assignments.\n"); sQL_Utils.SelectAssignment(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; case '4': Console.Clear(); Console.WriteLine("Select * From Courses.\n"); sQL_Utils.SelectCourse(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; case '5': Console.Clear(); Console.WriteLine("Students Per Course.\n"); sQL_Utils.SelectStudentPerCourse(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; case '6': Console.Clear(); Console.WriteLine("Trainers Per Course.\n"); sQL_Utils.SelectTrainerPerCourse(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; case '7': Console.Clear(); Console.WriteLine("Assignment Per Course.\n"); sQL_Utils.SelectAssignment(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; case '8': Console.Clear(); Console.WriteLine("Assignment Per Course Per Student.\n"); sQL_Utils.SelectAssignmentPerCoursePerStudent(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; case '9': Console.Clear(); Console.WriteLine("Students that belong to more than one course.\n"); sQL_Utils.SelectStudentsWithMoreCourse(); Console.WriteLine("\n Press Enter to return to SQL queries execution menu. "); Console.ReadLine(); SqlQueries(); break; default: Console.Clear(); Menu(); break; } }