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

        public virtual void TestMultipleJoinsWithJoinConditionsInWhere()
        {
            // this should reduce to inner joins
            var list = (
                from c in db.Customers
                from o in db.Orders
                from d in db.OrderDetails
                where o.CustomerID == c.CustomerID && o.OrderID == d.OrderID
                where c.CustomerID == "ALFKI"
                select d
                ).ToList();

            AssertValue(12, list.Count);
        }