BusinessLogic.Logic.BoardGameGeekGameDefinitions.UniversalGameRetriever.GetAllActiveBoardGameGeekGameDefinitionSitemapInfos C# (CSharp) Метод

        public List<UniversalGameSitemapInfo> GetAllActiveBoardGameGeekGameDefinitionSitemapInfos()
        {
            return _dataContext.GetQueryable<BoardGameGeekGameDefinition>()
                .Select(x =>  new UniversalGameSitemapInfo
                {
                    BoardGameGeekGameDefinitionId = x.Id,
                    DateCreated = x.DateCreated,
                    DateLastGamePlayed = x.GameDefinitions.SelectMany(y => y.PlayedGames
                        .Select(playedGame => playedGame.DatePlayed))
                        .OrderByDescending(date => date)
                        .FirstOrDefault()
                }).OrderBy(x => x.BoardGameGeekGameDefinitionId)
                .ToList();
        }