static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter3.media");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter6.toyota");
context.ExecuteStoreCommand("delete from chapter6.bmw");
context.ExecuteStoreCommand("delete from chapter6.cardealer");
context.ExecuteStoreCommand("delete from chapter6.dealer");
}
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
var d1 = new Dealer {
Name = "All Cities Toyota"
};
var d2 = new Dealer {
Name = "Southtown Toyota"
};
var d3 = new Dealer {
Name = "Luxury Auto World"
};
var c1 = new Toyota {
Model = "Camry", Color = "Green", Year = "2010", Dealer = d1
};
var c2 = new BMW {
Model = "310i", Color = "Blue", CollisionAvoidance = true, Year = "2010", Dealer = d3
};
var c3 = new Toyota {
Model = "Tundra", Color = "Blue", Year = "2010", Dealer = d2
};
context.Dealers.AddObject(d1);
context.Dealers.AddObject(d2);
context.Dealers.AddObject(d3);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
context.ContextOptions.LazyLoadingEnabled = true;
Console.WriteLine("Dealers and Their Cars");
Console.WriteLine("======================");
foreach (var dealer in context.Dealers)
{
Console.WriteLine("\nDealer: {0}", dealer.Name);
foreach (var car in dealer.Cars)
{
string make = string.Empty;
if (car is Toyota)
{
make = "Toyota";
}
else if (car is BMW)
{
make = "BMW";
}
Console.WriteLine("\t{0} {1} {2} {3}", car.Year, car.Color, make, car.Model);
}
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
context.Media.AddObject(new Article {
Title = "Woodworkers' Favorite Tools"
});
context.Media.AddObject(new Article {
Title = "Building a Cigar Chair"
});
context.Media.AddObject(new Video {
Title = "Upholstering the Cigar Chair"
});
context.Media.AddObject(new Video {
Title = "Applying Finish to the Cigar Chair"
});
context.Media.AddObject(new Picture {
Title = "Photos of My Cigar Chair"
});
context.Media.AddObject(new Video {
Title = "Tour of My Woodworking Shop"
});
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
var allMedia = from m in context.Media
let mediatype = m is Article ? 1 :
m is Video ? 2 : 3
orderby mediatype
select m;
Console.WriteLine("All Media sorted by type...");
foreach (var media in allMedia)
{
Console.WriteLine("Title: {0} [{1}]", media.Title, media.GetType().Name);
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
