public List<sp_Skill_DM> ListSkills(bool showNullMstrSkill) { List<sp_Skill_DM> list = new List<sp_Skill_DM>(); try { using (VolTeerEntities context = new VolTeerEntities()) { list = (from result in context.sp_Skill_Select_Manage(showNullMstrSkill) select new sp_Skill_DM { SkillID = result.SkillID, SkillName = result.SkillName, MstrSkillID = result.MstrSkillID, ActiveFlg = result.ActiveFlg, ReqCert = result.ReqCert }).ToList(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return list; }