Query.cs

Query.cs

            return (from item in xRitInfoService.All
                    join xApos in xAnalyses.All
                        on new
                        {
                            item.Bonnummer,
                            AnalyseSource = AnalyseSourceEnum.Apos
                        } equals new
                        {
                            xApos.Bonnummer,
                            xApos.AnalyseSource
                        } into xAllApos
                    join xLab in xAnalyses.All
                        on new
                        {
                            item.Bonnummer,
                            AnalyseSource = AnalyseSourceEnum.Lab
                        } equals new
                        {
                            xLab.Bonnummer,
                            xLab.AnalyseSource
                        } into xAllLab
                    where item.TijdstipIn != null
                    && item.Afgekeurd == afgekeurd
                    && item.LeverancierId == mLeverancierId
                    select new RitDetailObj
                    {
                        Bonnummer = item.Bonnummer,
                        Datum = item.TijdstipIn.Value,
                        AposAs = xAllApos.Average(i => i.Ash),
                        AposNcw = xAllApos.Average(i => i.Ncw),
                        AposDS = xAllApos.Average(i => i.DrogeStof),
                        LabAs = xAllLab.Average(i => i.Ash),
                        LabNcw = xAllLab.Average(i => i.Ncw),
                        LabDS = xAllLab.Average(i => i.DrogeStof),
                    });