private static void UpdateUntracked(Menu m)
{
using (var context = new MenusContext())
{
ShowState(context);
// EntityEntry<Menu> entry = context.Menus.Attach(m);
// entry.State = EntityState.Modified;
context.Menus.Update(m);
ShowState(context);
context.SaveChanges();
}
}
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 void UpdateRecords()
{
Console.WriteLine(nameof(UpdateRecords));
using (var context = new MenusContext())
{
Menu menu = context.Menus
.Skip(1)
.FirstOrDefault();
ShowState(context);
menu.Price += 0.2m;
ShowState(context);
int records = context.SaveChanges();
Console.WriteLine($"{records} updated");
ShowState(context);
}
Console.WriteLine();
}
private static void AddHundredRecords()
{
Console.WriteLine(nameof(AddHundredRecords));
using (var context = new MenusContext())
{
var card = context.MenuCards.FirstOrDefault();
if (card != null)
{
var menus = Enumerable.Range(1, 100).Select(x => new Menu
{
MenuCard = card,
Text = $"menu {x}",
Price = 9.9m
});
context.Menus.AddRange(menus);
int records = context.SaveChanges();
Console.WriteLine($"{records} added");
}
}
Console.WriteLine();
}
private static void AddHundredRecords()
{
Console.WriteLine(nameof(AddHundredRecords));
using (var context = new MenusContext())
{
var card = context.MenuCards.FirstOrDefault();
if (card != null)
{
var menus = Enumerable.Range(1, 100).Select(x => new Menu
{
MenuCard = card,
Text = $"menu {x}",
Price = 9.9m
});
context.Menus.AddRange(menus);
Stopwatch stopwatch = Stopwatch.StartNew();
int records = context.SaveChanges();
stopwatch.Stop();
Console.WriteLine($"{records} records added after {stopwatch.ElapsedMilliseconds} milliseconds");
}
}
Console.WriteLine();
}
