CQRS.Talk.Refactoring1.Queries.Step1.Repository.PeopleRepository.GetStaffEligibleForReview C# (CSharp) Метод

GetStaffEligibleForReview() публичный Метод

public GetStaffEligibleForReview ( ) : IEnumerable
Результат IEnumerable
        public IEnumerable<Person> GetStaffEligibleForReview()
        {
            const string sql = @"where 
                                    isCurrentlyEmployed = 1 
                                    and datediff(Year, DateOfJoin, GetDate()) >= 3 
                                    and isNewPensionScheme = 1";
            var people = database.Query<Person>(sql);

            return people;
        }