Advance_LINQ_Queries_15 | C# Online Compiler

Advance_LINQ_Queries_15 by StackFrontier

using System;
using System.Collections.Generic;
using System.Linq;

namespace ConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            // Prepare data
            var cities = new List<City>
            {
                new City
                {
                    Name = "New York",
                    Shops = new List<Shop>
                    {
                        new Shop
                        {
                            Name = "Shop 1",
                            Products = new List<Product>
                            {
                                new Product { Name = "Milk", Price = 2.5m },
                                new Product { Name = "Bread", Price = 1.5m }
                            }
                        },
                        new Shop
                        {
                            Name = "Shop 2",
                            Products = new List<Product>
                            {
                                new Product { Name = "Milk", Price = 3.0m },
                                new Product { Name = "Cheese", Price = 4.5m }
                            }
                        }
                    }
                },
                new City
                {
                    Name = "London",
                    Shops = new List<Shop>
                    {
                        new Shop
                        {
                            Name = "Shop 3",
                            Products = new List<Product>
                            {
                                new Product { Name = "Milk", Price = 2.0m },
                                new Product { Name = "Bread", Price = 1.0m }
                            }
                        },
                        new Shop
                        {
                            Name = "Shop 4",
                            Products = new List<Product>
                            {
                                new Product { Name = "Milk", Price = 2.5m },
                                new Product { Name = "Cheese", Price = 4.0m }
                            }
                        }
                    }
                }
            };

            // Use LINQ to find out the city where the average price of "Milk" is the lowest
            var cheapestCityForMilk = cities
                .Select(c => new
                {
                    City = c.Name,
                    AveragePrice = c.Shops.SelectMany(s => s.Products)
                                          .Where(p => p.Name == "Milk")
                                          .Average(p => p.Price)
                })
                .OrderBy(c => c.AveragePrice)
                .First();

            Console.WriteLine($"The city where the average price of \"Milk\" is the lowest is {cheapestCityForMilk.City} with an average price of {cheapestCityForMilk.AveragePrice}.");
        }
    }

    class City
    {
        public string Name { get; set; }
        public List<Shop> Shops { get; set; }
    }

    class Shop
    {
        public string Name { get; set; }
        public List<Product> Products { get; set; }
    }

    class Product
    {
        public string Name { get; set; }
        public decimal Price { get; set; }
    }
}

​x
 
using System;
using System.Collections.Generic;
using System.Linq;
​
namespace ConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            // Prepare data
            var cities = new List<City>
            {
                new City
                {
                    Name = "New York",
                    Shops = new List<Shop>
                    {
                        new Shop
                        {
                            Name = "Shop 1",
                            Products = new List<Product>
                            {
                                new Product { Name = "Milk", Price = 2.5m },
                                new Product { Name = "Bread", Price = 1.5m }
                            }
                        },
                        new Shop
                        {
                            Name = "Shop 2",
                            Products = new List<Product>
                            {
                                new Product { Name = "Milk", Price = 3.0m },
                                new Product { Name = "Cheese", Price = 4.5m }
                            }
                        }
                    }
                },
                new City
                {
                    Name = "London",
                    Shops = new List<Shop>
                    {
                        new Shop
                        {
                            Name = "Shop 3",
                            Products = new List<Product>
                            {
                                new Product { Name = "Milk", Price = 2.0m },
                                new Product { Name = "Bread", Price = 1.0m }
                            }
                        },
                        new Shop
                        {
                            Name = "Shop 4",
                            Products = new List<Product>
                            {
                                new Product { Name = "Milk", Price = 2.5m },
                                new Product { Name = "Cheese", Price = 4.0m }
                            }
                        }
                    }
                }
            };
​
            // Use LINQ to find out the city where the average price of "Milk" is the lowest
            var cheapestCityForMilk = cities
                .Select(c => new
                {
                    City = c.Name,
                    AveragePrice = c.Shops.SelectMany(s => s.Products)
                                          .Where(p => p.Name == "Milk")
                                          .Average(p => p.Price)
                })
                .OrderBy(c => c.AveragePrice)
                .First();
​
            Console.WriteLine($"The city where the average price of \"Milk\" is the lowest is {cheapestCityForMilk.City} with an average price of {cheapestCityForMilk.AveragePrice}.");
        }
    }
​
    class City
    {
        public string Name { get; set; }
        public List<Shop> Shops { get; set; }
    }
​
    class Shop
    {
        public string Name { get; set; }
        public List<Product> Products { get; set; }
    }
​
    class Product
    {
        public string Name { get; set; }
        public decimal Price { get; set; }
    }
}
​

Please enter a number

Last Run:	7:22:08 am
Compile:	0.202s
Execute:	0s
Memory:	32kb
CPU:	0.031s

View IL Code