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