BolfTracker.Infrastructure.EntityFramework.GameRepository.GetByMonthAndYear C# (CSharp) Method

        public IEnumerable<Game> GetByMonthAndYear(int month, int year)
        {
            using (var connection = BolfTrackerDbConnection.GetProfiledConnection())
            {
                connection.Open();

                string query = "SELECT * FROM Game WHERE (DATEPART (month, [Date])) = @Month AND (DATEPART (year, [Date])) = @Year";

                var games = connection.Query<Game>(query, new { Month = month, Year = year }).ToList();

                return games;
            }
        }