Esempio n. 1
0
        public List<sp_Skill_DM> ListSkills(Guid? Skill)
        {
            List<sp_Skill_DM> list = new List<sp_Skill_DM>();
            try
            {
                using (VolTeerEntities context = new VolTeerEntities())
                {
                    list = (from result in context.sp_Skill_Select(Skill)
                            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;
        }