public List <IPerformance> GetPastPerformances() { var reader = SQL.GetDataReader("usp_SelectPastPerformances"); var performances = new List <IPerformance>(); foreach (var item in reader) { var p = CreateFromReader(item); p.Venue = _venueRepository.CreateFromReader(item, "Venue"); performances.Add(p); } return(performances); }