private void btnDelete_Click(object sender, RoutedEventArgs e)
{
try
{
var custorder = lstOrders.SelectedItem;
System.Type type = custorder.GetType();
int orderid = (int)type.GetProperty("OrderID").GetValue(custorder, null);
Order odemo = ctx.Orders.Where(o => o.OrderID == orderid).ToList()[0];
var odt = ctx.Order_Details.Where(od => od.OrderID == orderid).ToList();
foreach(Order_Detail od in odt)
ctx.DeleteObject(od);
ctx.DeleteObject(odemo);
ctx.SaveChanges();
MessageBox.Show("Deleted!");
cmbCustomers_SelectionChanged(null, null);
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString());
}
}
Thursday, 3 May 2012
WCF DeleteObject
Because Orders table has a constaint to Order_Details table, the latter has to be deleted also with related Order.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment