How to convert normal foreach loop into lambda expression?

Question

·          public static Collection SalesPlan > GetCurrentPlan( PurchasePlanRequest purchasePlanRequest)         {             SalesCustomerManager salesCustomerManager = new SalesCustomerManager ();             SalesCustomer salesCustomer = new SalesCustomer ();                         salesCustomer.ReportingCustomerNumber = purchasePlanRequest.ReportingCustomerId;             Collection SalesPlan > salesPlanCollection = new Collection SalesPlan >();                        salesCustomer = salesCustomerManager.GetCustomerLinesPlansCoverages(salesCustomer);             Collection SalesPlan > renewalPlan = new Collection SalesPlan >();             Collection SalesPlan > currentPlan = new Collection SalesPlan >();                         foreach ( SalesLineOfBusiness lob in salesCustomer.SalesLineOfBusinessCollection)             {                 if (lob.LineOfBusinessCode == purchasePlanRequest.LOBCode)                 {                                         foreach ( SalesPlan salepln in lob.SalesPlanCollection)                     {                         //Compare PlanEffectiveDate is equal to CurrentRenewalDate.                         if (purchasePlanRequest.PlanEffectiveDate == currentRenewalDate)                         {                             if (salepln.IsRenewalPlan == true )                             {                                 currentPlan.Add(salepln);                             }                                                     }                         else                         {                             if (salepln.IsCurrentPlan == true )                             {                                 currentPlan.Add(salepln);                             }                                                    }                                         }                 }             }             return currentPlan;         } In the green color code foreach loop, I want to use Lambda expression instead of Foreach loop. Can anybody suggest me approach of doing so….

Vulpes · Accepted Answer

Not very elegant but try this:
Collection currentPlan = null;
currentPlan = new Collection                   ((from lob in salesCustomer.SalesLineOfBusinessCollection                     where lob.LineOfBusinessCode == purchasePlanRequest.LOBCode                     select lob                     into lob                     from salepln in lob.SalesPlanCollection                     where ((purchasePlanRequest.PlanEffectiveDate == currentRenewalDate) && salepln.IsRenewalPlan) ||                           ((purchasePlanRequest.PlanEffectiveDate != currentRenewalDate) && salepln.IsCurrentPlan)                       select salepln).ToList());