public void Test_DDShopContext_Init()
{
// test DDShopContext
using (var ctx = new DDShopContext())
{
}
}
public void Query_Order()
{
using (var ctx = new DDShopContext())
using (var tran = ctx.Database.BeginTransaction())
{
ctx.Database.Log = logger.Info;
var order = (from o in ctx.Orders.Include("OrderLine")
where o.MakeById == 2
select o).Single();
var orderItems = order.OrderLine.ToArray();
/*for (int i = 0; i < 100; i++)
* {
* var orderItem = new OrderItem("A-" + i);
* order.OrderLine.Add(orderItem);
* //ctx.OrderItems.Remove(orderItems[i]);
* }*/
//order.OrderLine.Add(orderItem);
//order.OrderLine.Remove(order.OrderLine.First());
//ctx.OrderItems.Remove(order.OrderLine.First());
//ctx.SaveChanges();
//var person = order.MakeBy;
//tran.Commit();
}
}
public void Change_Submt_Order()
{
var dbContextScopeFactory = new DbContextScopeFactory();
var ambientDbContextLocator = new AmbientDbContextLocator();
var orderRepository = new OrderRepository(ambientDbContextLocator);
var personRepository = new PersonRepository(ambientDbContextLocator);
using (var dbContextScope = dbContextScopeFactory.CreateWithTransaction(IsolationLevel.ReadCommitted))
{
var oldOrder = orderRepository.GetByOrderNo("6de3772b-6047-4d99-8bbf-bcf3d71bfc8d");
oldOrder.Status = ValueObjects.OrderStatus.Summited;
/*var person = personRepository.GetByName("ding.pp");
* person.Name = "ding.p";*/
//dbContextScope.SaveChanges();
}
try
{
using (var ctx = new DDShopContext())
{
var oldOrder = (from o in ctx.Orders
where o.OrderNo == "6de3772b-6047-4d99-8bbf-bcf3d71bfc8d"
select o).Single();
oldOrder.Status = ValueObjects.OrderStatus.Draft;
ctx.SaveChanges();
}
}
catch (DbEntityValidationException dbEx)
{
foreach (DbEntityValidationResult entityErr in dbEx.EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
Console.WriteLine("Error Property Name {0} : Error Message: {1}",
error.PropertyName, error.ErrorMessage);
}
}
}
}
