public List<StudentRecord> Execute() { DynamicQueryStatement dqs = ToDynamicQueryStatement(); try { StudentsContext context = new StudentsContext(); List<StudentRecord> students = context.StudentRecords.Where(dqs.Query, dqs.Parms) .OrderBy(x => x.LastName + x.FirstName + x.MiddleInitial) .ToList(); return students; } catch (Exception ex) { AnvilExceptionCollector ec = new AnvilExceptionCollector("Could not get students from database"); ec.Add(ex); ec.Add(dqs.Query); throw ec.ToException(); } }
public static List<StudentRecord> GetStudents(DynamicQueryStatement dqs) { try { StudentsContext db = new StudentsContext(); return db.StudentRecords.Where(dqs.Query, dqs.Parms) .OrderBy( x => x.LastName + x.FirstName + x.MiddleInitial) .ToList(); } catch (Exception ex) { throw new Exception("Could not get students from database", ex); } }