// method to delete record into database public static void DeleteRestaurantFromDB(string sRestaurantInput) { try { RestaurantReviewP0Entities db; using (db = new RestaurantReviewP0Entities()) { Restaurant restaurant = db.Restaurants.SingleOrDefault(x => x.rName == sRestaurantInput); db.Restaurants.Attach(restaurant); db.Entry(restaurant).State = EntityState.Deleted; db.Restaurants.Remove(restaurant); db.SaveChanges(); } } catch (DbUpdateConcurrencyException duce) { Console.WriteLine("Exception handled:\n" + duce.Message); Console.WriteLine("Stack Trace:\n" + duce.StackTrace); } catch (SqlException se) { Console.WriteLine("Exception handled:\n" + se.Message); Console.WriteLine("Stack Trace:\n" + se.StackTrace); } catch (DbException de) { Console.WriteLine("Exception handled:\n" + de.Message); Console.WriteLine("Stack Trace:\n" + de.StackTrace); } catch (ExternalException ee) { Console.WriteLine("Exception handled:\n" + ee.Message); Console.WriteLine("Stack Trace:\n" + ee.StackTrace); } catch (SystemException syse) { Console.WriteLine("Exception handled:\n" + syse.Message); Console.WriteLine("Stack Trace:\n" + syse.StackTrace); } catch (Exception e) { Console.WriteLine("Exception handled:\n" + e.Message); Console.WriteLine("Stack Trace:\n" + e.StackTrace); } }
public static void DeleteReviewFromDB(string sRName, string sRSummary) { try { RestaurantReviewP0Entities db = new RestaurantReviewP0Entities(); Review review = db.Reviews.SingleOrDefault(x => x.rName == sRName); db.Reviews.Attach(review); db.Entry(review).State = EntityState.Deleted; db.Reviews.Remove(review); db.SaveChanges(); } catch (SqlException se) { Console.WriteLine("Exception handled:\n" + se.Message); Console.WriteLine("Stack Trace:\n" + se.StackTrace); } catch (DbException de) { Console.WriteLine("Exception handled:\n" + de.Message); Console.WriteLine("Stack Trace:\n" + de.StackTrace); } catch (ExternalException ee) { Console.WriteLine("Exception handled:\n" + ee.Message); Console.WriteLine("Stack Trace:\n" + ee.StackTrace); } catch (SystemException syse) { Console.WriteLine("Exception handled:\n" + syse.Message); Console.WriteLine("Stack Trace:\n" + syse.StackTrace); } catch (Exception e) { Console.WriteLine("Exception handled:\n" + e.Message); Console.WriteLine("Stack Trace:\n" + e.StackTrace); } }