/// <summary> /// Return a list of Sample addresses using LINQ to SQL /// </summary> /// <returns></returns> public List<sp_Email_DM> ListEmails() { List<sp_Email_DM> list = new List<sp_Email_DM>(); try { using (VolTeerEntities context = new VolTeerEntities()) { list = (from result in context.sp_Vol_Email_Select(null) select new sp_Email_DM { EmailID = result.EmailID, EmailAddr = result.EmailAddr, VolID = result.VolID, ActiveFlg = result.ActiveFlg }).ToList(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return list; }
public sp_Email_DM ListPrimaryEmail(sp_Email_DM cVolEmail) { sp_Email_DM item = new sp_Email_DM(); try { using (VolTeerEntities context = new VolTeerEntities()) { item = (from result in context.sp_Vol_Email_Select(cVolEmail.VolID, null, true) select new sp_Email_DM { EmailID = result.EmailID, EmailAddr = result.EmailAddr, VolID = result.VolID, ActiveFlg = result.ActiveFlg, PrimaryFlg = result.PrimaryFlg }).FirstOrDefault(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return item; }