public List<sp_VolSkill_DM> ListVolSkills(Guid VolID) { List<sp_VolSkill_DM> list = new List<sp_VolSkill_DM>(); try { using (VolTeerEntities context = new VolTeerEntities()) { list = (from result in context.sp_VolSkill_Select(VolID) select new sp_VolSkill_DM { SkillID = result.SkillID, MstrSkillID = result.MstrSkillID, SkillName = result.SkillName }).ToList(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return list; }