IEnumerables: Scenario I

IEnumberable_scenario_one.cs

        public void Test()
        {
            //Method I
            var soLineSplitsLinkedWithCurrentPO =
                SelectFrom<SOLineSplit>
                    .Where<SOLineSplit.pOType.IsEqual<@P.AsString.ASCII>.And<SOLineSplit.pONbr.IsEqual<@P.AsString>>>
                    .AggregateTo<GroupBy<SOLineSplit.orderType>, GroupBy<SOLineSplit.orderNbr>>
                    .View.Select(this, row.OrderType, row.OrderNbr);
            foreach (var item in soLineSplitsLinkedWithCurrentPO)
            { }
            
            //Method II
            var lines = SelectFrom<SOLineSplit>
                .Where<SOLineSplit.pOType.IsEqual<@P.AsString.ASCII>.And<SOLineSplit.pONbr.IsEqual<@P.AsString>>>
                .View.Select(this, row.OrderType, row.OrderNbr).RowCast<SOLine>().ToList();

            var groupedby = lines.GroupBy(x => new {x.OrderType, x.OrderNbr});
            var warehouse_count = lines.Select(l => l.SiteID).Distinct().Count();
            foreach (var item in groupedby)
            {
                var subgroup = lines.Where(x => x.OrderType == item.Key.OrderType && x.OrderNbr == item.Key.OrderNbr);
            }
        }