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