difficulty making Foreach lambda in a query

Question

I have this query

var qry = _productRepository.Table.GroupJoin(_categoriesRepository.Table,
            p => p.CategoryId,
            c => c.Id,
            (p, c) => new { Product = p, Categories = c.DefaultIfEmpty() })
            .Where(hdg => hdg.Product.Hidden == false)
            .AsNoTracking()
            .SelectMany(final => final.Categories,
            (final, c) => new CatalogItemResponse
            {
                ChildrenCategoryId = final.Product.ChildrenCategoryId,

                DolarRate = 0.0m,
                ResellerPriceUSD = 0.0m,
                ResellerPriceBRL = 0.0m,
                BasePriceBRL = 0.0m,
                BasePriceUSD = 0.0m,

                CategoryId = final.Product.CategoryId,
                CategoryName = (c != null ? c.Name : null),
                PictureId = final.Product.PictureId,
                Description = final.Product.Description,
                ShortDescription = final.Product.ShortDescription,
                Name = final.Product.Name,
                NameHtml = string.IsNullOrEmpty(final.Product.NameHtml) ? final.Product.Name : final.Product.NameHtml,
                PartNumber = final.Product.PartNumber,
                Hidden = final.Product.Hidden,
                Order = final.Product.Order,
                HaveMaximumPercentage = final.Product.HaveMaximumPercentage,
                MaximumPercentage = final.Product.MaximumPercentage,
                HaveMinimumPercentage = final.Product.HaveMinimumPercentage,
                MinimumPercentage = final.Product.MinimumPercentage,
                AuthorizeMaximumPercentageAlteration = final.Product.AuthorizeMaximumPercentageAlteration,
                AuthorizeMinimumPercentageAlteration = final.Product.AuthorizeMinimumPercentageAlteration,
                StandardMarkup = final.Product.StandardMarkup,
                DistributionCenterErpId = final.Product.DistributionCenterErpId,
                PictureFilename = final.Product.Picture.FileName

            }).ToList();

Before this lambda I had a Getall() and then I would foreach and take this line the way it is

if (product.PictureId.HasValue)
    q.PictureFilename = product.Picture.FileName;

Well, what I need is to take that same value, but assigning it within qry.Foreach and I’m not sure how to do it. I started trying it that way

 qry.ForEach(prd => prd.PictureFilename = ??????)

That’s right, that’s the way?

EDIT1

I did so by putting the Picture class in Left Join, but what do I assign in Select new? I gave an anonymous select new, what do I do? Any value I try to set, gives error at the bottom

var qry = _productRepository.Table.GroupJoin(_categoriesRepository.Table,
            p => p.CategoryId,
            c => c.Id,
            (p, c) => new { Product = p, Categories = c.DefaultIfEmpty() })

            .GroupJoin(_pictureRepository.Table,
            prd => prd.Product.PictureId,
            pic => pic.Id,
            (prd, pic) => new { Product = prd.Product, Pictures = pic.DefaultIfEmpty()})
            .SelectMany(sel => sel.Pictures,
            (sel, pic) => new
            {

            })

            .Where(hdg => hdg.Product.Hidden == false)            
            .SelectMany(final => final.Categories,
            (final, c) => new CatalogItemResponse
            {
                ChildrenCategoryId = final.Product.ChildrenCategoryId,
                //atribuições.................

Include that

GroupJoin(_pictureRepository.Table,
                prd => prd.Product.PictureId,
                pic => pic.Id,
                (prd, pic) => new { Product = prd.Product, Pictures = pic.DefaultIfEmpty()})
                .SelectMany(sel => sel.Pictures,
                (sel, pic) => new
                {

                })

See this screenshot of the error on top of that line: .Where(hdg => hdg.Product.Hidden == false)

Answer 1

In fact the correct syntax would be ForEach():

qry.ForEach(prd => {
    //DoSomething
});

See if it fits your problem:

var qry = _productRepository.Table.GroupJoin(_categoriesRepository.Table,
          p => p.CategoryId,
          c => c.Id,
          (p, c) => new { Product = p, Categories = c.DefaultIfEmpty() })
          .Where(hdg => hdg.Product.Hidden == false)
          .AsNoTracking()
          .ToList()
          .ForEach(PropertyDescriptor => {
            //DoSomething
          });

var listCatalogItems = qry
        .SelectMany(final => final.Categories,
        (final, c) => new CatalogItemResponse
        {
          ChildrenCategoryId = final.Product.ChildrenCategoryId,

          DolarRate = 0.0m,
          ResellerPriceUSD = 0.0m,
          ResellerPriceBRL = 0.0m,
          BasePriceBRL = 0.0m,
          BasePriceUSD = 0.0m,

          CategoryId = final.Product.CategoryId,
          CategoryName = (c != null ? c.Name : null),
          PictureId = final.Product.PictureId,
          Description = final.Product.Description,
          ShortDescription = final.Product.ShortDescription,
          Name = final.Product.Name,
          NameHtml = string.IsNullOrEmpty(final.Product.NameHtml) ? final.Product.Name : final.Product.NameHtml,
          PartNumber = final.Product.PartNumber,
          Hidden = final.Product.Hidden,
          Order = final.Product.Order,
          HaveMaximumPercentage = final.Product.HaveMaximumPercentage,
          MaximumPercentage = final.Product.MaximumPercentage,
          HaveMinimumPercentage = final.Product.HaveMinimumPercentage,
          MinimumPercentage = final.Product.MinimumPercentage,
          AuthorizeMaximumPercentageAlteration = final.Product.AuthorizeMaximumPercentageAlteration,
          AuthorizeMinimumPercentageAlteration = final.Product.AuthorizeMinimumPercentageAlteration,
          StandardMarkup = final.Product.StandardMarkup,
          DistributionCenterErpId = final.Product.DistributionCenterErpId,
          PictureFilename = final.Product.Picture.FileName

        }).ToList();