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

        public virtual void TestBigQueryWithOrderingGroupingAndNestedGroupCounts()
        {
            var query = db.Customers
                          .OrderBy(c => c.City)
                          .Take(10)
                          .GroupBy(c => c.City)
                          .OrderBy(g => g.Key)
                          .Select(g => new { Key = g.Key, ItemCount = g.Count(), HasSubGroups = false, Items = g });

            var results = query.ToList();
        }
    }