Northwind db = new Northwind(Connections.ConnectionString);
Order_Detail orderDetail = db.Order_Details.Single(
o => o.OrderID == 10248
		&& o.ProductID == 42);

if (orderDetail.Quantity >= 10) {
	orderDetail.Discount = 0.05F;
}

using (TransactionScope ts = new TransactionScope()) {
db.SubmitChanges();
ts.Complete();
}
