return _requirementRepository.DataSet.Where(i => i.IsDeleted == 0 i.Location.UpTreeLocations.Any(ut => ut.Id == locationId) && ( i.ApplicationType == corpScopeString) || i.ApplicationScopes.Count == 0 || i.ApplicationScopes.Any(s => s.Segments.Any(ss => authorizedSegmentIds.Contains(ss.Segment_Id)))).Project().To<DTORequirementListing>(); the above query fails at last condition i.ApplicationScopes.Any(s => s.Segments.Any(ss => authorizedSegmentIds.Contains(ss.Segment_Id)))).Project().To<dtorequirementlisting>(); Getting error :{"ORA-00904: \"Project2\".\"C1\": invalid identifier"} All Models are mapped properly as per oracle convention. Not able to resolve with help of sql generated query. Any suggestion?</dtorequirementlisting>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)