public static void GetCustomersByOrders(int year, string shipping)
    {
        ////Option 1.
        //var myOrders = db.Orders
        //    .Join(db.Customers, o => o.CustomerID, c => c.CustomerID, (o, c) => new
        //    {
        //        CompanyName = c.CompanyName,
        //        OrderDate = o.OrderDate,
        //        ShipCountry = o.ShipCountry
        //    })
        //    .Where(x => x.ShipCountry == shipping && year.CompareTo(x.OrderDate.Value.Year) == 0)
        //    //.Select(y => y.CompanyName)
        //    //.Distinct()
        //    .ToList();

        //Option 2.
        var myOrders = db.Orders
            .Where(x => x.ShipCountry == shipping && year.CompareTo(x.OrderDate.Value.Year) == 0)
            .Select(y => y.Customer.CompanyName)
            .Distinct()
            .ToList();

        foreach (var order in myOrders)
        {
            ////Option 1
            //Console.WriteLine("{0}", order.CompanyName);

            //Option 2.
            Console.WriteLine("{0}", order);
        }

        Console.WriteLine(myOrders.Count());
    }