public static async Task PreparationAsync() { using (var context = new MenusContext()) { bool deleted = await context.Database.EnsureDeletedAsync(); string deletedText = deleted ? "deleted" : "does not exist"; WriteLine($"database {deletedText}"); bool created = await context.Database.EnsureCreatedAsync(); string createdText = created ? "created" : "already exists"; WriteLine($"database {createdText}"); var card = new MenuCard() { Title = "Meat" }; var m1 = new Menu { MenuCard = card, Text = "Wiener Schnitzel", Price = 12.90m }; var m2 = new Menu { MenuCard = card, Text = "Goulash", Price = 8.80m }; card.Menus.AddRange(new Menu[] { m1, m2 }); context.MenuCards.Add(card); int records = await context.SaveChangesAsync(); WriteLine($"{records} records added"); } }
private static void InitialFill() { MenuCard[] cards = new MenuCard[] { new MenuCard { } }; using (var context = new MenusContext()) { } }
private static void AddRecords() { Console.WriteLine(nameof(AddRecords)); try { using (var context = new MenusContext()) { var soupCard = new MenuCard(); Menu[] soups = { new Menu { Text = "Consommé Célestine (with shredded pancake)", Price = 4.8m, MenuCard = soupCard }, new Menu { Text = "Baked Potato Soup", Price = 4.8m, MenuCard = soupCard }, new Menu { Text = "Cheddar Broccoli Soup", Price = 4.8m, MenuCard = soupCard }, }; soupCard.Title = "Soups"; soupCard.Menus.AddRange(soups); context.MenuCards.Add(soupCard); ShowState(context); int records = context.SaveChanges(); Console.WriteLine($"{records} added"); Console.WriteLine(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.WriteLine(); }
private static async Task AddRecordsAsync() { WriteLine(nameof(AddRecordsAsync)); try { using (var context = new MenusContext()) { var soupCard = new MenuCard(); Menu[] soups = { new Menu { Text = "Consommé Célestine (with shredded pancake)", Price = 4.8m, MenuCard =soupCard}, new Menu { Text = "Baked Potato Soup", Price = 4.8m, MenuCard = soupCard }, new Menu { Text = "Cheddar Broccoli Soup", Price = 4.8m, MenuCard = soupCard }, }; soupCard.Title = "Soups"; soupCard.Menus.AddRange(soups); context.MenuCards.Add(soupCard); ShowState(context); int records = await context.SaveChangesAsync(); WriteLine($"{records} added"); WriteLine(); } } catch (Exception ex) { WriteLine(ex.Message); } WriteLine(); }