/// <summary> /// Return a list of Sample projects using LINQ to SQL /// </summary> /// <returns></returns> public List<sp_Project_DM> ListProjects() { List<sp_Project_DM> list = new List<sp_Project_DM>(); try { using (VolTeerEntities context = new VolTeerEntities()) { list = (from result in context.sp_Project_Select(null) select new sp_Project_DM { ProjectID = result.ProjectID, ProjectName = result.ProjectName, ProjectDesc = result.ProjectDesc, AddrID = result.AddrID, ActiveFlg = result.ActiveFlg }).ToList(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return list; }