static void Main(string[] args) { NorthwndQueries queries = new NorthwndQueries(ConfigurationManager.AppSettings["connectionString"]); NorthwndConsoleUi ui = new NorthwndConsoleUi(); ui.Add(() => queries.Q1(), "Show all info about the employee with ID 8."); ui.Add(() => queries.Q2(), "Show the list of first and last names of the employees from London."); ui.Add(() => queries.Q3(), "Show the list of first and last names of the employees whose first name begins with letter A."); ui.Add(() => queries.Q5(), "Calculate the count of employees from London."); ui.Add(() => queries.Q9(), "Show the first and last name(s) of the eldest employee(s)."); ui.Add(() => queries.Q10(), "Show first, last names and ages of 3 eldest employees."); ui.Add(() => queries.Q11(), "Show the list of all cities where the employees are from"); ui.Add(() => queries.Q13(), "Show first and last names of the employees who used to serve orders shipped to Madrid."); ui.Add(() => queries.Q17(), "Show the count of orders made by each customer from France."); ui.Add(() => queries.Q19(), "Show the list of french customers’ names who have made more than one order"); ui.Add(() => queries.Q30(), "Show the list of cities where employees and customers are from and where orders have been made to. Duplicates should be eliminated."); ui.Add(() => queries.Q33(), "Change the City field in one of your records using the UPDATE statement."); using (queries) { ui.Launch(); } }