IEnumerable<Contracts.UniversityData> IUniversityDataRepository.GetDataByState(string state) { using (UniversityDataEntities context = new UniversityDataEntities()) { IList<Contracts.UniversityData> details = new List<Contracts.UniversityData>(); IEnumerable<UniversityDetail> fullDetails = context.UniversityDetails.Where(n => n.STABBR.Equals(state)).ToList(); foreach (UniversityDetail item in fullDetails) { details.Add(new Contracts.UniversityData { UNITID = item.UNITID.Value, INSTNM = item.INSTNM, ADDR = item.ADDR, CITY = item.CITY, STABBR = item.STABBR, ZIP = item.ZIP, WEBADDR = item.WEBADDR }); } return details; } }