public List <State> GetAllStates() { using (ContactManagerContext ctx = new ContactManagerContext()) { var states = from s in ctx.States select s; return(states.ToList()); } }
public List <Contact> GetAllContacts() { List <Contact> contacts = null; using (ContactManagerContext ctx = new ContactManagerContext()) { contacts = (from c in ctx.Contacts .Include("Address") select c).ToList(); } return(contacts); }
public Contact GetContactById(long id) { Contact contact = null; using (ContactManagerContext ctx = new ContactManagerContext()) { contact = (from c in ctx.Contacts .Include("Address") where c.ID == id select c).SingleOrDefault(); } return(contact); }
public Contact AddContact(Contact contact) { if (contact == null) { throw new ArgumentNullException("contact"); } using (ContactManagerContext ctx = new ContactManagerContext()) { ctx.Contacts.Add(contact); ctx.SaveChanges(); } return(contact); }