static void Main(string[] args) { // This code reads the connection string from appsettings.json IConfigurationBuilder builder = new ConfigurationBuilder(); builder.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); // Get the connection string for the World database string connectionString = configuration.GetConnectionString("World"); CitySqlDAO cityDAO = new CitySqlDAO(connectionString); List <City> cities = cityDAO.GetAllCities(); foreach (City city in cities) { Console.WriteLine($"{city.Id,5} {city.Name,-40} {city.Population,12:N0} "); } Console.ReadLine(); cities = cityDAO.GetCitiesForCountryCode("GBR"); foreach (City city in cities) { Console.WriteLine($"{city.Id,5} {city.Name,-40} {city.Population,12:N0} "); } // GetAllCities(connectionString) // GetCitiesForCountry(connectionString, "USA"); Console.ReadLine(); return; // TODO: Create a City Model class // TODO: Create a City SQL DAO Class (GetCities, GetCitiesByCountryCode) // TODO: List the cities of the world // TODO: List the cities in a Country (code) // TODO: Add a City to the US // TODO: Create instances of DAOs to pass into the menus // TODO: Create a WorldDBMenu and Run it WorldDBMenu menu = new WorldDBMenu(); menu.Run(); // Say goodbye to the user... Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("Goodbye..."); Thread.Sleep(1500); }