convert to linq notation - "_dataContext.EventFrames.AsNoTracking()
                        .Where(acquisition => acquisition.Name == "Проверки" &&
                                              acquisition.ChildEventFrames.Any(runningCheck => runningCheck.Name == "Текущие проверки машины") &&
                                              acquisition.Attributes.FirstOrDefault(attr => attr.Name == "Состояние").Value == "Активна"
                        )
                        .Where(acquisition => acquisition.Attributes.Where(attribute => attribute.Name == "Обработка" || attribute.Name == "Поверхность" || attribute.Name == "Внешний лак")
                                    .All(attribute => string.IsNullOrWhiteSpace(attribute.Value))
                        )
                        .SelectMany(acquisition => acquisition.ChildEventFrames
                                                .Where(runningCheck => runningCheck.Name == "Текущие проверки машины")
                                                .Select(runningCheck => new { RunningCheckGuid = runningCheck.ObjectId, PartName = runningCheck.Attributes.FirstOrDefault(attr => attr.Name == "Изделие").Value })
                                                .Select(runningCheck => new {
                                                    AcquisitionId = acquisition.ObjectId,
                                                    AcquisitionName = acquisition.Attributes.FirstOrDefault(attr => attr.Name == "Проверка").Value,
                                                    Size = acquisition.Attributes.FirstOrDefault(attr => attr.Name == "Размер банки").Value,
                                                    Neck = acquisition.Attributes.FirstOrDefault(attr => attr.Name == "Горло").Value,
                                                    Coating = acquisition.Attributes.FirstOrDefault(attr => attr.Name == "Наполнение").Value,
                                                    Gauge = acquisition.Attributes.FirstOrDefault(attr => attr.Name == "Толщина метала").Value,
                                                    RunningCheckGuid = runningCheck.RunningCheckGuid,
                                                    PartName = runningCheck.PartName
                                                })
                        )
                        .Join(_dataContext.EventFrames.AsNoTracking()
                                            .Where(part => string.Equals(part.Name, "Изделие") &&
                                                           !string.IsNullOrWhiteSpace(part.Attributes.FirstOrDefault(x => x.Name == "Номер материала").Value)
                                            )
                                            .Select(part => new
                                            {
                                                PartType = part.Attributes.FirstOrDefault(attr => attr.Name == "Тип материала").Value,
                                                PartName = part.Attributes.FirstOrDefault(attr => attr.Name == "Номер материала").Value,
                                                Size = part.Attributes.FirstOrDefault(attr => attr.Name == "Размер банки").Value,
                                                Coating = part.Attributes.FirstOrDefault(attr => attr.Name == "Используемый напиток").Value,
                                                Neck = part.Attributes.FirstOrDefault(attr => attr.Name == "Размер горла").Value,
                                                Gauge = part.Attributes.FirstOrDefault(attr => attr.Name == "Толщина метала").Value,
                                                PartDescription = part.Attributes.FirstOrDefault(attr => attr.Name == "Наименование материала (Ru)").Value,
                                                PartNumber = part.Attributes.FirstOrDefault(x => x.Name == "Номер материала").Value
                                            }),
                            (acquisition) => acquisition.PartName,
                            (part) => part.PartNumber,
                            (acquisition, part) => new
                            {
                                AcquisitionId = acquisition.AcquisitionId,
                                AcquisitionName = acquisition.AcquisitionName,
                                AcquisitionSize = acquisition.Size,
                                AcquisitionNeck = acquisition.Neck,
                                AcquisitionCoating = acquisition.Coating,
                                AcquisitionGauge = acquisition.Gauge,
                                RunningCheckGuid = acquisition.RunningCheckGuid,
                                PartType = part.PartType,
                                PartName = part.PartName,
                                PartSize = part.Size,
                                PartCoating = part.Coating,
                                PartNeck = part.Neck,
                                PartGauge = part.Gauge,
                                PartDescription = part.PartDescription,
                                PartNumber = part.PartNumber
                            })
                        .Where(acquisitionWithPart =>
                            (acquisitionWithPart.AcquisitionSize == acquisitionWithPart.PartSize || acquisitionWithPart.AcquisitionSize == null || acquisitionWithPart.AcquisitionSize == "") &&
                            (acquisitionWithPart.AcquisitionNeck == acquisitionWithPart.PartNeck || acquisitionWithPart.AcquisitionNeck == null || acquisitionWithPart.AcquisitionNeck == "") &&
                            (acquisitionWithPart.AcquisitionCoating == acquisitionWithPart.PartCoating || acquisitionWithPart.AcquisitionCoating == null || acquisitionWithPart.AcquisitionCoating == "") &&
                            (acquisitionWithPart.AcquisitionGauge == acquisitionWithPart.PartGauge || acquisitionWithPart.AcquisitionGauge == null || acquisitionWithPart.AcquisitionGauge == "")
                        )
                        .Select(acquisitionWithPart => acquisitionWithPart.RunningCheckGuid);"