NLite.Data.Test.NorthwindExecutionTest.TestOrderByDistinct C# (CSharp) Method

        public virtual void TestOrderByDistinct()
        {
            // these are un-ordered, because using distinct negates any existing ordering.
            var list = db.Customers.Where(c => c.City.StartsWith("P")).OrderBy(c => c.City).Select(c => c.City).Distinct().ToList();
            AssertValue(2, list.Count);
            var sorted = list.OrderBy(x => x).ToList();
            AssertValue(2, list.Count);
            AssertValue(sorted[0], "Paris");
            AssertValue(sorted[1], "Portland");
        }