static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter15.invoice");
context.ExecuteStoreCommand("delete from chapter15.client");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter8.donation");
context.ExecuteStoreCommand("delete from chapter8.donor");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter7.servicecall");
context.ExecuteStoreCommand("delete from chapter7.technician");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter10.message");
context.ExecuteStoreCommand("delete from chapter10.member");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter5.employee");
context.ExecuteStoreCommand("delete from chapter5.department");
context.ExecuteStoreCommand("delete from chapter5.company");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter11.reservation");
context.ExecuteStoreCommand("delete from chapter11.visitor");
context.ExecuteStoreCommand("delete from chapter11.hotel");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter14.account");
}
}
static void Cleanup()
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter2.picturecategory");
}
}
static void RunExample()
{
using (var context = new EFRecipesEntities())
{
context.Accounts.AddObject(new Account {
AccountNumber = "8675309", Balance = 100M, Name = "Robin Rosen"
});
context.Accounts.AddObject(new Account {
AccountNumber = "8535937", Balance = 25M, Name = "Steven Bishop"
});
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
// get the account
var account = context.Accounts.First(a => a.AccountNumber == "8675309");
Console.WriteLine("Account for {0}", account.Name);
Console.WriteLine("\tPrevious Balance: {0}", account.Balance.ToString("C"));
// some other process updates the balance
Console.WriteLine("[Rogue process updates balance!]");
context.ExecuteStoreCommand("update chapter14.account set balance = 1000 where accountnumber = '8675309'");
// update the account balance
account.Balance = 10M;
try
{
Console.WriteLine("\tNew Balance: {0}", account.Balance.ToString("C"));
context.SaveChanges();
}
catch (OptimisticConcurrencyException ex)
{
Console.WriteLine("Exception: {0}", ex.Message);
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
protected void Page_Load(object sender, EventArgs e)
{
using (var context = new EFRecipesEntities())
{
// cleanup from previous tests
context.ExecuteStoreCommand("delete from chapter4.productdetail");
context.ExecuteStoreCommand("delete from chapter4.orderdetail");
context.ExecuteStoreCommand("delete from chapter4.product");
context.ExecuteStoreCommand("delete from chapter4.category");
context.ExecuteStoreCommand("delete from chapter4.supplier");
// add in our test data
var s1 = new Supplier {
CompanyName = "Backcountry Supply", Country = "USA"
};
var s2 = new Supplier {
CompanyName = "Alpine Tent", Country = "Italy"
};
var s3 = new Supplier {
CompanyName = "Ace Footware", Country = "USA"
};
var c1 = new Category {
CategoryName = "Tents"
};
var c2 = new Category {
CategoryName = "Shoes/Boots"
};
var pd1 = new ProductDetail {
UnitPrice = 99.95M
};
var pd2 = new ProductDetail {
UnitPrice = 129.95M
};
var pd3 = new ProductDetail {
UnitPrice = 39.95M
};
var p1 = new Product {
ProductName = "Pup Tent", ProductDescription = "Small and packable tent", Discontinued = true, UnitsInStock = 4
};
var p2 = new Product {
ProductName = "Trail Boot", ProductDescription = "Perfect boot for hiking", Discontinued = false, UnitsInStock = 19
};
var p3 = new Product {
ProductName = "Family Tent", ProductDescription = "Sleeps 2 adults + 2 children", Discontinued = false, UnitsInStock = 10
};
var od1 = new OrderDetail {
UnitPrice = 39.95M, Quantity = 1
};
var od2 = new OrderDetail {
UnitPrice = 129.95M, Quantity = 2
};
var od3 = new OrderDetail {
UnitPrice = 99.95M, Quantity = 1
};
p1.Supplier = s2;
p1.Category = c1;
p1.ProductDetail = pd3;
p1.OrderDetails.Add(od1);
p2.Supplier = s3;
p2.Category = c2;
p2.OrderDetails.Add(od2);
p2.ProductDetail = pd2;
p3.Supplier = s1;
p3.Category = c1;
p3.ProductDetail = pd1;
p3.OrderDetails.Add(od3);
context.Products.AddObject(p1);
context.Products.AddObject(p2);
context.Products.AddObject(p3);
context.SaveChanges();
}
}