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); } } } }