Multiple queries with PetaPoco

databaseacess

 var planEmployees = this.DB
                          .Query<Xhr.Data.Model.EmployeeLeavePlanView>("WHERE LeavePlanId=@0", p.Id);
                
                planEmployees.ForEach(e =>
                {
                    var creditHistory = this.LeavesService.GetCredits(e.ID);
                    var newCredits = creditCalculator.CalculateNewCredits(processStartTime, creditHistory);