0

I have a following query for some nested implementation

return _context.baseTable1.Where(h => h.id == Id ).Select(lev => new
            {
                Contact = (lev.baseTable2 != null
                                    && lev.baseTable2.baseTable3 != null
                                    && lev.baseTable2.baseTable3.baseTable5.Any(h => h.contact != null)
                                    ? lev.baseTable2.baseTable3.baseTable5.Where(h => h.contact != null).GroupBy(h => h.contact).Select(c=>c.FirstOrDefault().contact) : null),
                Key1 = lev.office != null ? lev.office.id, : null,
                Key2 = lev.baseTable2 != null && lev.baseTable2.baseTable3 != null && lev.baseTable2.baseTable3.baseTable4 != null ?
                                lev.baseTable2.baseTable3.baseTable4.id : null

            }).ToList().SelectMany(x =>
            {
                if (!x.Contact.Any())
                {
                    return new List<FinalModel> { new FinalModel { Key1 = x.Key1, Key2 = x.Key2 } };
                }
                else
                    return x.Contact.Select(contact => new FinalModel()
                    {
                        ContactKey = contact.id,
                        Key1 = x.Key1,
                        Key2 = x.Key2
                    });
            });

It was created via help from GroupBy then Select with conditional record addition

But now getting above error

Kamran Shahid
  • 3,954
  • 5
  • 48
  • 93

0 Answers0