public void DeleteUser(string name) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { User user = (from u in context.Users where (u.Name == name) select u).First(); if (user != null) { context.DeleteObject(user); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeleteContact(int id) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Contact contact = (from ct in context.Contacts where (ct.Id == id) select ct).First(); if (contact != null) { context.DeleteObject(contact); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeletePartyContact(int partyId, int contactId) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyContact partyContact = (from pc in context.PartyContacts where (pc.PartyId == partyId && pc.ContactId == contactId) select pc).First(); if (partyContact != null) { context.DeleteObject(partyContact); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeleteParty(int id) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { using (TransactionScope txnScope = new TransactionScope(TransactionScopeOption.Required)) { Party party = (from p in context.Parties where (p.Id == id) select p).First(); if (party != null) { var partyContacts = from partyContact in context.PartyContacts where (partyContact.PartyId == id) select partyContact; foreach (PartyContact toRemove in partyContacts) { context.DeleteObject(toRemove); context.SaveChanges(); } context.DeleteObject(party); context.SaveChanges(); context.AcceptAllChanges(); txnScope.Complete(); } } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeleteUser(string name) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { User user = (from u in context.Users where (u.Name == name) select u).First(); if (user != null) { context.DeleteObject(user); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeletePartyContact(int partyId, int contactId) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { PartyContact partyContact = (from pc in context.PartyContacts where (pc.PartyId == partyId && pc.ContactId == contactId) select pc).First(); if (partyContact != null) { context.DeleteObject(partyContact); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeleteParty(int id) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { using (TransactionScope txnScope = new TransactionScope(TransactionScopeOption.Required)) { Party party = (from p in context.Parties where (p.Id == id) select p).First(); if (party != null) { var partyContacts = from partyContact in context.PartyContacts where (partyContact.PartyId == id) select partyContact; foreach (PartyContact toRemove in partyContacts) { context.DeleteObject(toRemove); context.SaveChanges(); } context.DeleteObject(party); context.SaveChanges(); context.AcceptAllChanges(); txnScope.Complete(); } } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }
public void DeleteContact(int id) { try { using (PartyEntities context = new PartyEntities(this.connectionString)) { Contact contact = (from ct in context.Contacts where (ct.Id == id) select ct).First(); if (contact != null) { context.DeleteObject(contact); context.SaveChanges(); } } } catch (Exception ex) { if (ex is UpdateException) { throw ex.InnerException; } throw; } }