public static void RemoveNoteTypeMembership(NoteTypeMembership toRemove) { using (ProMaDB scope = new ProMaDB()) { scope.NoteTypeMemberships.Attach(toRemove); scope.NoteTypeMemberships.Remove(toRemove); scope.SaveChanges(); } }
public static void AddNoteTypeMembership(NoteTypeMembership toAdd) { lock (TransactionLocks.StringLock) { using (ProMaDB scope = new ProMaDB()) { // if this membership already exists, recreate it with the new information NoteTypeMembership existingMembership = scope.NoteTypeMemberships.FirstOrDefault(x => x.UserId == toAdd.UserId && x.NoteTypeId == toAdd.NoteTypeId); if (existingMembership != null) { scope.NoteTypeMemberships.Remove(existingMembership); scope.SaveChanges(); } scope.NoteTypeMemberships.Add(toAdd); scope.Entry(toAdd).State = EntityState.Added; scope.SaveChanges(); } } }