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);
}
