partial void UpdateOrderDetail(OrderDetail instance);
private void detach_OrderDetails(OrderDetail entity) { this.SendPropertyChanging(); entity.Product = null; }
partial void InsertOrderDetail(OrderDetail instance);
private void CleanupInsert08() { SetLogging(false); OrderDetail od = new OrderDetail() { ProductID = 11, Quantity = 12, UnitPrice = 14, OrderID = 10248, Discount = 0 }; db.OrderDetails.InsertOnSubmit(od); db.SubmitChanges(); }
private void attach_OrderDetails(OrderDetail entity) { this.SendPropertyChanging(); entity.Order = this; }
private void OrderDetails_Attach(OrderDetail entity) { this.SendPropertyChanging(); entity.Product = this; }
private void Cleanup70() { SetLogging(false); Order order = new Order() { CustomerID = "WARTH", EmployeeID = 3, OrderDate = new DateTime(1996, 7, 26), RequiredDate = new DateTime(1996, 9, 6), ShippedDate = new DateTime(1996, 7, 31), ShipVia = 3, Freight = 25.73M, ShipName = "Wartian Herkku", ShipAddress = "Torikatu 38", ShipCity = "Oulu", ShipPostalCode="90110", ShipCountry = "Finland" }; //Order, Cus, Emp, OrderD, ReqD, ShiD, ShipVia, Frei, ShipN, ShipAdd, ShipCi, ShipReg, ShipPostalCost, ShipCountry //10266 WARTH 3 1996-07-26 00:00:00.000 1996-09-06 00:00:00.000 1996-07-31 00:00:00.000 3 25.73 Wartian Herkku Torikatu 38 Oulu NULL 90110 Finland OrderDetail orderDetail = new OrderDetail() { ProductID = 12, UnitPrice = 30.40M, Quantity = 12, Discount = 0.0F }; order.OrderDetails.Add(orderDetail); db.Orders.InsertOnSubmit(order); db.SubmitChanges(); }
public void CP4_UnchangedColumnShouldNotUpdated() { Random rand = new Random(); Northwind db = CreateDB(); var orderDetail = new OrderDetail { OrderID = 1, ProductID=2}; db.OrderDetails.Attach(orderDetail); float newDiscount = 15 + (float)rand.NextDouble(); orderDetail.Discount = newDiscount; db.SubmitChanges(); //this test is bad conceptually, for this reason last two lines has been commented and now a changeConflictException is expected. //This is the behaviour in linq2sl. //var orderDetail2 = db.OrderDetails.Single(od => od.OrderID == 1); //Assert.AreEqual((float)orderDetail2.Discount, newDiscount); }
public void CP2_UpdateTableWithCompositePK() { Northwind db = CreateDB(); cleanup(db); var order = db.Orders.First(); var product = db.Products.First(); var startUnitPrice = 33000; var endUnitPrice = 34000; var orderDetail = new OrderDetail { OrderID = order.OrderID, ProductID = product.ProductID, Quantity = TestQuantity, UnitPrice = startUnitPrice }; db.OrderDetails.InsertOnSubmit(orderDetail); db.SubmitChanges(); orderDetail.UnitPrice = endUnitPrice; db.SubmitChanges(); OrderDetail orderDetail2 = (from c in db.OrderDetails where c.UnitPrice == endUnitPrice select c).Single(); Assert.IsTrue(object.ReferenceEquals(orderDetail, orderDetail2), "Must be same object"); Assert.AreEqual(order.OrderID, orderDetail2.OrderID); Assert.AreEqual(product.ProductID, orderDetail2.ProductID); Assert.AreEqual(endUnitPrice, orderDetail2.UnitPrice); db.OrderDetails.DeleteOnSubmit(orderDetail); db.SubmitChanges(); }
public void OrderDetails_Detach(OrderDetail entity) { entity.Product = null; }
public void CP3_DeleteTableWithCompositePK() { Northwind db = CreateDB(); cleanup(db); int initialCount = db.OrderDetails.Count(); var order = db.Orders.First(); var product = db.Products.First(); var orderDetail = new OrderDetail { OrderID = order.OrderID, ProductID = product.ProductID, Quantity = TestQuantity }; db.OrderDetails.InsertOnSubmit(orderDetail); db.SubmitChanges(); Assert.AreEqual(db.OrderDetails.Count(), initialCount + 1); db.OrderDetails.DeleteOnSubmit(orderDetail); db.SubmitChanges(); Assert.AreEqual(db.OrderDetails.Count(), initialCount); }
public void OrderDetails_Attach(OrderDetail entity) { entity.Product = this; }
public void OrderDetails_Detach(OrderDetail entity) { entity.Order = null; }
public void OrderDetails_Attach(OrderDetail entity) { entity.Order = this; }
partial void DeleteOrderDetail(OrderDetail instance);
private void Cleanup69() { SetLogging(false); OrderDetail orderDetail = new OrderDetail() { OrderID = 10255, ProductID = 36, UnitPrice = 15.200M, Quantity = 25, Discount = 0.0F }; db.OrderDetails.InsertOnSubmit(orderDetail); db.SubmitChanges(); }
public void NotExistingAttatch() { Random rand = new Random(); Northwind db = CreateDB(); var orderDetail = new OrderDetail { OrderID = 0, ProductID = 0 }; db.OrderDetails.Attach(orderDetail); float newDiscount = 15 + (float)rand.NextDouble(); orderDetail.Discount = newDiscount; db.SubmitChanges(); }
private void OrderDetails_Detach(OrderDetail entity) { this.SendPropertyChanging(); entity.Order = null; }