static void Main(string[] args)
{
using (var context = new EFRecipesEntities())
{
context.ExecuteStoreCommand("delete from chapter6.weborder");
}
using (var context = new EFRecipesEntities())
{
var order = new WebOrder {
CustomerName = "Jim Allen", OrderDate = DateTime.Parse("5/3/2009"), IsDeleted = false, Amount = 200
};
context.WebOrders.AddObject(order);
order = new WebOrder {
CustomerName = "John Stevens", OrderDate = DateTime.Parse("1/1/2006"), IsDeleted = false, Amount = 400
};
context.WebOrders.AddObject(order);
order = new WebOrder {
CustomerName = "Russel Smith", OrderDate = DateTime.Parse("1/3/2006"), IsDeleted = true, Amount = 500
};
context.WebOrders.AddObject(order);
order = new WebOrder {
CustomerName = "Mike Hammer", OrderDate = DateTime.Parse("3/6/2006"), IsDeleted = true, Amount = 1800
};
context.WebOrders.AddObject(order);
order = new WebOrder {
CustomerName = "Steve Jones", OrderDate = DateTime.Parse("1/1/2003"), IsDeleted = true, Amount = 600
};
context.WebOrders.AddObject(order);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
Console.WriteLine("Orders");
Console.WriteLine("======");
foreach (var order in context.WebOrders)
{
Console.WriteLine("\nCustomer: {0}", order.CustomerName);
Console.WriteLine("OrderDate: {0}", order.OrderDate.ToShortDateString());
Console.WriteLine("Is Deleted: {0}", order.IsDeleted.ToString());
Console.WriteLine("Amount: {0}", order.Amount.ToString("C"));
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}
/// <summary>
/// Create a new WebOrder object.
/// </summary>
/// <param name="orderId">Initial value of the OrderId property.</param>
/// <param name="customerName">Initial value of the CustomerName property.</param>
/// <param name="orderDate">Initial value of the OrderDate property.</param>
/// <param name="isDeleted">Initial value of the IsDeleted property.</param>
/// <param name="amount">Initial value of the Amount property.</param>
public static WebOrder CreateWebOrder(global::System.Int32 orderId, global::System.String customerName, global::System.DateTime orderDate, global::System.Boolean isDeleted, global::System.Decimal amount)
{
WebOrder webOrder = new WebOrder();
webOrder.OrderId = orderId;
webOrder.CustomerName = customerName;
webOrder.OrderDate = orderDate;
webOrder.IsDeleted = isDeleted;
webOrder.Amount = amount;
return(webOrder);
}
/// <summary>
/// Deprecated Method for adding a new object to the WebOrders EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToWebOrders(WebOrder webOrder)
{
base.AddObject("WebOrders", webOrder);
}
