private static void Update(EF_CRUD_Entities ef_crud_entities)
{
Customer larry = ef_crud_entities.Customer.FirstOrDefault(c => c.CustName.Equals("LarrySU"));
if (larry != null)
{
larry.CustName = "LarrySu";
ef_crud_entities.SaveChanges();
}
}
private static void Delete(EF_CRUD_Entities ef_crud_entities)
{
Customer larry = ef_crud_entities.Customer.FirstOrDefault(c => c.CustName.Equals("LarrySu"));
if (larry != null)
{
// already set Cascade
ef_crud_entities.Customer.Remove(larry);
ef_crud_entities.SaveChanges();
}
}
private static void Create(EF_CRUD_Entities ef_crud_entities)
{
Customer larry = new Customer {
CustName = "LarrySU", Created = System.DateTime.Now, Modified = System.DateTime.Now
};
ef_crud_entities.Customer.Add(larry);
Order order = new Order {
CustId = larry.Id, IsExpress = true, Created = System.DateTime.Now, Modified = System.DateTime.Now
};
ef_crud_entities.Order.Add(order);
OrderDetail order_detail = new OrderDetail {
OrderId = order.Id, ItemName = "蒜頭", Count = 2, Created = System.DateTime.Now, Modified = System.DateTime.Now
};
ef_crud_entities.OrderDetail.Add(order_detail);
ef_crud_entities.SaveChanges();
}