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);
}
}
