Modern C# and .NET Tutorial: Cross-Platform Basics/

...

/

Solution: Querying with LINQ

Solution: Querying with LINQ

Look at the solution to the previous challenge.

We'll cover the following...

Problem statement

The task involves creating a code that prompts the user to input a city. The program should generate a list of company names corresponding to Northwind database customers located in the specified city. As an addition, before prompting the user for their preferred city, the code should display a list of all unique cities already populated by customers as follows:

Aachen, Albuquerque, Anchorage, Århus, Barcelona, Barquisimeto, Bergamo,
Berlin, Bern, Boise, Bräcke, Brandenburg, Bruxelles, Buenos Aires, Butte,
Campinas, Caracas, Charleroi, Cork, Cowes, Cunewalde, Elgin, Eugene, Frankfurt
a.M., Genève, Graz, Helsinki, I. de Margarita, Kirkland, Kobenhavn, Köln,
Lander, Leipzig, Lille, Lisboa, London, Luleå, Lyon, Madrid, Mannheim,
Marseille, México D.F., Montréal, München, Münster, Nantes, Oulu, Paris,
Portland, Reggio Emilia, Reims, Resende, Rio de Janeiro, Salzburg, San
Cristóbal, San Francisco, Sao Paulo, Seattle, Sevilla, Stavern, Strasbourg,
Stuttgart, Torino, Toulouse, Tsawassen, Vancouver, Versailles, Walla Walla,
Warszawa
...