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

        public virtual void TestJoinIntoCustomersOrdersCount()
        {
            var list = (
                from c in db.Customers
                where c.CustomerID == "ALFKI"
                join o in db.Orders on c.CustomerID equals o.CustomerID into ords
                select new { cust = c, ords = ords.Count() }
                ).ToList();
            AssertValue(1, list.Count);
            AssertValue(6, list[0].ords);
        }