public static void DeleteDependencies(long id) { var ctx = new DataClassesDataContext(); // Prescription's dependency is PrescriptionDetail var prescriptionDetails = from p in ctx.PrescriptionDetails where p.PrescriptionID == id select p; foreach (var prescriptionDetail in prescriptionDetails) { PrescriptionDetailOperations.DeleteDependencies(prescriptionDetail.ID); } ctx.PrescriptionDetails.DeleteAllOnSubmit(prescriptionDetails); // submit all changes ctx.SubmitChanges(); }
public static void DeleteDependencies(long id) { var ctx = new DataClassesDataContext(); // drug's denpendency is prescription detail var prescriptionDetails = from p in ctx.PrescriptionDetails where p.DrugID == id select p; // delete all their dependencies foreach (var prescriptionDetail in prescriptionDetails) { PrescriptionDetailOperations.DeleteDependencies(prescriptionDetail.ID); } // delete all those prescription details ctx.PrescriptionDetails.DeleteAllOnSubmit(prescriptionDetails); ctx.SubmitChanges(); }