BolfTracker.Infrastructure.EntityFramework.GameRepository.GetActiveMonthsAndYears C# (CSharp) Метод

        public IEnumerable<Tuple<int, int>> GetActiveMonthsAndYears()
        {
            using (var connection = BolfTrackerDbConnection.GetProfiledConnection())
            {
                connection.Open();

                string query = "SELECT (DATEPART(MONTH, [Date])) AS Month, (DATEPART(YEAR, [Date])) AS Year FROM Game GROUP BY (DATEPART(MONTH, [Date])), (DATEPART (year, [Date]))";

                var rows = connection.Query(query);
                var monthsAndYears = new List<Tuple<int, int>>();

                foreach (var row in rows)
                {
                    monthsAndYears.Add(new Tuple<int, int>(row.Month, row.Year));
                }

                return monthsAndYears;
            }
        }