static void FindAllSalesByDateRange(string region, int startDate, int endDate)
    {
        using (NORTHWNDEntities db = new NORTHWNDEntities())
        {
            var sales = from order in db.Orders
                        join orderDetails in db.Order_Details
                        on order.OrderID equals orderDetails.OrderID
                        where (order.ShipRegion == region && order.OrderDate.Value.Year == startDate && order.ShippedDate.Value.Year == endDate)
                        select new
                        {
                            Quantity = orderDetails.Quantity,
                            Region = order.ShipRegion,
                            Country = order.ShipCountry
                        };

            foreach (var sale in sales)
            {
                Console.WriteLine("Ship Region: {0}, Ship Country: {1}, Order Quantity: {2}",
                                    sale.Region,sale.Country,sale.Quantity);
            }
        }
    }