static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter12.salesorder");
context.ExecuteStoreCommand("delete from chapter12.customer");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter3.topselling");
context.ExecuteStoreCommand("delete from chapter3.product");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter15.article");
context.ExecuteStoreCommand("delete from chapter15.video");
context.ExecuteStoreCommand("delete from chapter15.media");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter6.member");
}
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
var client1 = new Client {
Name = "Karen Standfield", ClientId = 1
};
var invoice1 = new Invoice {
InvoiceDate = DateTime.Parse("4/1/10"), Amount = 29.95M
};
var invoice2 = new Invoice {
InvoiceDate = DateTime.Parse("4/2/10"), Amount = 49.95M
};
var invoice3 = new Invoice {
InvoiceDate = DateTime.Parse("4/3/10"), Amount = 102.95M
};
var invoice4 = new Invoice {
InvoiceDate = DateTime.Parse("4/4/10"), Amount = 45.99M
};
// add the invoice
// to the client's collection
client1.Invoices.Add(invoice1);
// assign the foreign key
// directly
invoice2.ClientId = 1;
// Attach() and existing
// row using a "fake" entity
context.ExecuteStoreCommand("insert into chapter5.client values (2, 'Phil Marlowe')");
var client2 = new Client {
ClientId = 2
};
context.Clients.Attach(client2);
invoice3.Client = client2;
// using the ClientReference
invoice4.ClientReference.Value = client1;
// save the changes
context.Clients.AddObject(client1);
context.Invoices.AddObject(invoice2);
context.Invoices.AddObject(invoice3);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
foreach (var client in context.Clients)
{
Console.WriteLine("Client: {0}", client.Name);
foreach (var invoice in client.Invoices)
{
Console.WriteLine("\t{0} for {1}", invoice.InvoiceDate.ToShortDateString(), invoice.Amount.ToString("C"));
}
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
