Subsonic -- Y U NO

SchoolPrograms2.cs

        public List<ProgramStructure> getSchoolPrograms(string eduComplete, string schoolCode, string areaOfInterest)
        {
            int eduBasement = SubQuery.getEduIDBasement(eduComplete);
            int edu = SubQuery.getEduID(eduComplete);
            int schoolid = SubQuery.getSchoolID(schoolCode);
            int areaOfInterestID = SubQuery.getAOIID(areaOfInterest);

            var Programs = from p in Program.All()
                           join d in Degree.All() on p.DegreeID equals d.DegreeID
                           join dc in DegreeCategory.All() on d.DegreeCategoryID equals dc.DegreeCategoryID
                           where p.Active == true && p.SchoolID == schoolid
                           && p.AreaOfInterest == areaOfInterestID && d.DegreeCategoryID > (eduBasement - 1)
                           && d.DegreeCategoryID < (edu + 1)
                            select new ProgramStructure()
                            {
                                programCode = p.ProgramCode,
                                programTitle = p.ProgramTitle,
                                DegreeCategoryTitle = dc.CategoryTitle
                            };
            List<ProgramStructure> prog = Programs.ToList();
            return prog;