Database Reference
In-Depth Information
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
// order over $5,000 and shipping not free
using (var context = new EFRecipesEntities())
{
var customer = new Customer { Name = "Phil Marlowe" };
var order = new SalesOrder { OrderDate = DateTime.Parse("3/12/10"),
Amount = 6200M, Status = "Approved",
ShippingCharge = 59.95M,
Customer = customer };
context.Customers.AddObject(customer);
context.SaveChanges();
try
{
order.Shipped = true;
order.ShippedDate = DateTime.Parse("3/13/10");
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
// order deleted after it was shipped
using (var context = new EFRecipesEntities())
{
var customer = new Customer { Name = "Phil Marlowe" };
var order = new SalesOrder { OrderDate = DateTime.Parse("3/12/10"),
Amount = 19.95M, Status = "Approved",
ShippingCharge = 3.95M,
Customer = customer };
context.Customers.AddObject(customer);
context.SaveChanges();
order.Shipped = true;
order.ShippedDate = DateTime.Parse("3/13/10");
context.SaveChanges();
try
{
context.DeleteObject(order);
context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
}
Search WWH ::




Custom Search