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();
}
