private void AddFoodShop() { using (var db = new Model1Container()) { try { Console.Write("Enter a name for a Shop: "); var shopName = Console.ReadLine(); Shop shopNew = null; shopNew = new Shop { Name = shopName }; // Create and save a new Food Console.Write("Enter a name for a new Food: "); var name = Console.ReadLine(); var food = new Food { Name = name }; //food.Shop = shopNew ; //db.Foods.Add(food); shopNew.Food.Add(food); db.Shops.Add(shopNew); db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Console.WriteLine(dbEx.Message); } // Display all Foods from the database var query = from f in db.Foods orderby f.Name select f; Console.WriteLine("All Foods in the database:"); foreach (var item in query) { Console.WriteLine(item.Name); } Console.WriteLine("Press any key to exit..."); Console.ReadKey(); } }
private void OptimisticConcurrencyTest() { using(var context = new Model1Container()){ bool saveFlag = false; Food food = context.Foods.Find(1); food.Price = 13; do { saveFlag = false; try { context.Database.ExecuteSqlCommand("update foods set price=14 where id=1"); context.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { saveFlag = true; ex.Entries.Single().Reload(); } } while (saveFlag); } }