Sorting Includes

var query = _context.Orders.Include("OrderDetails").Select(o => new { o, SortedOrderDetails = o.OrderDetails.OrderByDescending(od => od.UnitPrice) });

[TestMethod]

        public void TestSortingDealPricing()

        {

            //in the database, this deal has 2 pricings

            //8052 is for 2001-4000 volume

            //8053 is for    1-2000 volume

            //these need to be sorted by volume in the deal object

            Deal deal = Deal.Fetch(10094);

            

            //first, lets assert that they aren't sorted properly

            Assert.AreEqual(2, deal.DealPricings.Count);

            Assert.AreEqual(8052, deal.DealPricings[0].DealPricingId);

            Assert.AreEqual(8053, deal.DealPricings[1].DealPricingId);



            //ok.  that worked.  now we need to figure out how to get those items

            //loaded and sorted properly



            //let's try a straight load

            var em = LocalEntityManager.DefaultManager;

            em.Clear();

            var qry = em.Deals

                .Include(Deal.EntityPropertyNames.DealPricings)

                .Where(item => item.DealId == 10094)

                .With(QueryStrategy.DataSourceOnly);

            Deal deal2 = qry.Execute().First();

            Assert.AreEqual(2, deal2.DealPricings.Count);

            Assert.AreEqual(8052, deal2.DealPricings[0].DealPricingId);

            Assert.AreEqual(8053, deal2.DealPricings[1].DealPricingId);

            

            //so that didn't sort them (no surprise there)

            //let's try the recommendation from eileenv

            //http://www.ideablade.com/forum/forum_posts.asp?TID=1423

            em.Clear();

            qry = em.Deals

                .Include(Deal.EntityPropertyNames.DealPricings)

                .Where(item => item.DealId == 10094)

                .Select(item => new {item, SortedDealPricings 

                    = item.DealPricings.OrderByDescending(dp => dp.VolumeMin)})

                .With(QueryStrategy.DataSourceOnly);

            Deal deal3 = qry.Execute().First();

            Assert.AreEqual(2, deal3.DealPricings.Count);

            //note: the details are reversed here

            Assert.AreEqual(8053, deal3.DealPricings[0].DealPricingId);

            Assert.AreEqual(8052, deal3.DealPricings[1].DealPricingId);

        }

var query = _context.Orders

  .Include("OrderDetails")

  .Select(o => new { o, SortedOrderDetails = o.OrderDetails.OrderByDescending(od => od.UnitPrice) });

var orderDetails = query.ToList().Select(o => o.SortedOrderDetails);

Order.cs:

    public IEnumerable<OrderDetail> SortedOrderDetails {

      get { return this.OrderDetails.OrderByDescending(od => od.UnitPrice); }

    }

var query = _context.Orders.Include("OrderDetails");

var order = query.ToList().First();

// get sorted

var sortedOrderDetails = order.SortedOrderDetails;

// get unsorted

var unsortedOrderDetails = order.OrderDetails;

Deal deal3 = qry.Execute().First();

deal3.DealPricings.OrderBy((x) => x.VolumeMin);

Assert.AreEqual(2, deal3.DealPricings.Count);

//note: the details are reversed here

Assert.AreEqual(8053, deal3.DealPricings[0].DealPricingId);

Assert.AreEqual(8052, deal3.DealPricings[1].DealPricingId);

var sortedPrices = deal3.DealPricings.OrderBy((x) => x.VolumeMin);

Assert.AreEqual(2, sortedPrices.Count());

//note: the details are reversed here

Assert.AreEqual(8053, sortedPrices.ElementAt(0).DealPricingId);

Assert.AreEqual(8052, sortedPrices.ElementAt(1).DealPricingId);