public string GetFirstCollege() { using (GigALoan_DAL.DB_42039_gigEntities context = new GigALoan_DAL.DB_42039_gigEntities()) { var college = context.SPRT_Colleges.First(); return(college.CollegeName); } }
public List <DTO_College> GetColleges() { List <DTO_College> returnList = new List <DTO_College>(); using (GigALoan_DAL.DB_42039_gigEntities context = new GigALoan_DAL.DB_42039_gigEntities()) { var list = context.SPRT_Colleges.Take(10).ToList(); foreach (var c in list) { var college = new DTO_College(); college.CollegeID = c.CollegeID; college.CollegeName = c.CollegeName; returnList.Add(college); } return(returnList); } }