private void FindShop() { using(var context = new Model1Container()){ var food = context.Foods.Find(1); Console.WriteLine(food.Name); Console.Read(); } }
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); } }
private void UpdateFoodBySql() { using(var context = new Model1Container()){ context.Database.ExecuteSqlCommand("update foods set price = 10 where foods.id=1"); } Console.WriteLine("update success"); Console.ReadKey(); }
private void SearchShopBySql2() { using (var context = new Model1Container()) { var shops = context.Database.SqlQuery<shop2>("select s.name as name,s.id as id, f.name as foodName from shops s,foods f where s.id = f.shop_id").ToList(); foreach (var shop in shops) Console.WriteLine(shop.name+" "+shop.id+" "+shop.foodName); Console.Read(); } }
private void SearchShopBySql() { using(var context = new Model1Container()){ var shops = context.Shops.SqlQuery("select * from shops").ToList(); foreach (var shop in shops) Console.WriteLine(shop.Name); Console.Read(); } }
private void SearchShopbyFood3() { //Console.Write("Enter a name for a exist Food: "); //var name = Console.ReadLine(); using (var context = new Model1Container()) { var shops = context.Shops; foreach (var shop in shops) Console.WriteLine(" " + shop.Food.First().Name); } Console.Read(); }
private void SearchShopbyFood2() { Console.Write("Enter a name for a exist Food: "); var name = Console.ReadLine(); using (var context = new Model1Container()) { var food = context.Foods.Where(f => f.Name.Equals(name)).FirstOrDefault(); Console.WriteLine(" " + food.Shop.Name); } SearchShopbyFood2(); }
private void SearchShopbyFood() { Console.Write("Enter a name for a exist Food: "); var subname = Console.ReadLine(); using (var context = new Model1Container()) { var foods = from f in context.Foods where f.Name.StartsWith(subname) select f; foreach (var food in foods) { Console.WriteLine(" " + food.Shop.Name); } } SearchShopbyFood(); }