private void DeleteSupplierDisconnected(Supplier supplier) { using (var ctx = new OrderITEntities()) { ctx.Companies.Attach(supplier); ctx.DeleteObject(supplier); ctx.SaveChanges(); MessageBox.Show("Supplier deleted"); } }
private void btnDeleteCustomer_Click(object sender, EventArgs e) { using (var ctx = new OrderITEntities()) { var id = Convert.ToInt32(CustomerId.Text); var customer = ctx.Companies.OfType <Customer>().First(c => c.CompanyId == id); ctx.DeleteObject(customer); ctx.SaveChanges(); MessageBox.Show("Customer deleted"); } }
private void btnDeleteCustomerDisconnected_Click(object sender, EventArgs e) { using (var ctx = new OrderITEntities()) { Customer cust = new Customer() { CompanyId = Convert.ToInt32(CustomerId.Text), BillingAddress = new AddressInfo(), ShippingAddress = new AddressInfo() }; ctx.Companies.Attach(cust); ctx.DeleteObject(cust); ctx.SaveChanges(); MessageBox.Show("Customer deleted"); } }
private void Save_Click(object sender, EventArgs e) { var datasource = ((BindingList <Order>)orderBindingSource.DataSource); foreach (var order in datasource.Where(o => o.OrderId == 0)) { ctx.Orders.AddObject(order); } ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Modified).Select(c => c.Entity).OfType <OrderDetail>().Where(c => c.Order == null).ToList().ForEach(c => ctx.DeleteObject(c)); ctx.SaveChanges(); }
private void Button_Click(object sender, RoutedEventArgs e) { ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Modified).Select(c => c.Entity).OfType <OrderDetail>().Where(c => c.Order == null).ToList().ForEach(c => ctx.DeleteObject(c)); ctx.DetectChanges(); MessageBox.Show(orderDataGrid.Items.Count.ToString() + "-" + ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Added).Count() + "-" + ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Modified).Count() + "-" + ctx.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Deleted).Count()); //ctx.SaveChanges(); }