static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter3.[order]");
context.ExecuteStoreCommand("delete from chapter3.account");
}
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
var a1 = new Account {
City = "Raytown", State = "MO"
};
a1.Orders.Add(new Order {
Amount = 223.09M, ShipCity = "Raytown", ShipState = "MO"
});
a1.Orders.Add(new Order {
Amount = 189.32M, ShipCity = "Olathe", ShipState = "KS"
});
var a2 = new Account {
City = "Kansas City", State = "MO"
};
a2.Orders.Add(new Order {
Amount = 99.29M, ShipCity = "Kansas City", ShipState = "MO"
});
var a3 = new Account {
City = "North Kansas City", State = "MO"
};
a3.Orders.Add(new Order {
Amount = 102.29M, ShipCity = "Overland Park", ShipState = "KS"
});
context.Accounts.AddObject(a1);
context.Accounts.AddObject(a2);
context.Accounts.AddObject(a3);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
var orders = from o in context.Orders
join a in context.Accounts on
new { Id = o.AccountId, City = o.ShipCity, State = o.ShipState }
equals
new { Id = a.AccountId, City = a.City, State = a.State }
select o;
Console.WriteLine("Orders shipped to the account's city, state...");
foreach (var order in orders)
{
Console.WriteLine("\tOrder {0} for {1}", order.AccountId.ToString(), order.Amount.ToString("C"));
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
