BusinessLogic.Logic.GamingGroups.GamingGroupRetriever.GetGamingGroupsSitemapInfo C# (CSharp) Method

        public List<GamingGroupSitemapInfo> GetGamingGroupsSitemapInfo()
        {
            return dataContext.GetQueryable<GamingGroup>()
                .Select(x => new GamingGroupSitemapInfo
                {
                    GamingGroupId = x.Id,
                    DateCreated = x.DateCreated,
                    DateLastGamePlayed =
                        x.PlayedGames.OrderByDescending(playedGame => playedGame.DatePlayed).Select(playedGame => playedGame.DatePlayed).FirstOrDefault() 
                })
                .OrderBy(x => x.GamingGroupId)
                .ToList();
        }
    }