public List<sp_ProjectEventContact_DM> ListEventsContacts(Guid? EventID,Guid? ContactID) { List<sp_ProjectEventContact_DM> list = new List<sp_ProjectEventContact_DM>(); try { using (VolTeerEntities context = new VolTeerEntities()) { list = (from result in context.sp_ProjectEventContact_Select(EventID,ContactID) select new sp_ProjectEventContact_DM { EventID = result.EventID, ContactID = result.ContactID, PrimaryContact = result.PrimaryContact }).ToList(); } // Guaranteed to close the Connection } catch (Exception ex) { throw (ex); } return list; }