public void DeleteFromRepository(UdListItem udListItem) { if (_repositoryContext.GetEntityDescriptor(udListItem) != null) { //if it exists in the db delete it from the db UdListEntities context = new UdListEntities(_rootUri); context.MergeOption = MergeOption.AppendOnly; context.IgnoreResourceNotFoundException = true; UdListItem deletequery = (from q in context.UdListItems where q.UdListItemID == udListItem.UdListItemID && q.CompanyID == udListItem.CompanyID select q).FirstOrDefault(); if (deletequery != null) { context.DeleteObject(deletequery); context.SaveChanges(); } context = null; _repositoryContext.MergeOption = MergeOption.AppendOnly; //if it is being tracked remove it... if (GetUdListItemEntityState(udListItem) != EntityStates.Detached) { _repositoryContext.Detach(udListItem); } } }
public void CommitRepository() { _repositoryContext.MergeOption = MergeOption.AppendOnly; _repositoryContext.SaveChanges(); }