public void Delete(int userId) { var deletedItem = addressEntities.Users.Find(userId); addressEntities.Users.Remove(deletedItem); addressEntities.SaveChanges(); }
public void DeleteFromRepository(Address address) { if (_repositoryContext.GetEntityDescriptor(address) != null) {//if it exists in the db delete it from the db AddressEntities context = new AddressEntities(_rootUri); context.MergeOption = MergeOption.AppendOnly; context.IgnoreResourceNotFoundException = true; Address deletedAddress = (from q in context.Addresses where q.AddressID == address.AddressID select q).FirstOrDefault(); if (deletedAddress != null) { context.DeleteObject(deletedAddress); context.SaveChanges(); } context = null; _repositoryContext.MergeOption = MergeOption.AppendOnly; //if it is being tracked remove it... if (GetAddressEntityState(address) != EntityStates.Detached) { _repositoryContext.Detach(address); } } }
protected void Button2_Click(object sender, EventArgs e) { Address myAddress = new Address(); myAddress.FirstName = txtFirst.Text; myAddress.LastName = txtLast.Text; myAddress.PhoneNumber = txtPhone.Text; myAddress.Email = txtEmail.Text; dbcon.Addresses.Add(myAddress); dbcon.SaveChanges(); GridView1.DataBind(); }
public void CommitRepository() { _repositoryContext.MergeOption = MergeOption.AppendOnly; _repositoryContext.SaveChanges(); }