protected void NewProduct_Click(object sender, EventArgs e)
{
NorthwindDataContext db = new NorthwindDataContext();
Product p = new Product();
p.ProductName = "delete me";
p.UnitPrice = 4.30m;
db.Products.InsertOnSubmit(p);
db.SubmitChanges();
}
protected void Lame_Click(object sender, EventArgs e)
{
using (TransactionScope ts = new TransactionScope())
{
NorthwindDataContext db = new NorthwindDataContext();
var r = from p in db.Products
where p.UnitPrice > 15 &&
p.Order_Details.Sum(x => x.Quantity) < 200
select p;
db.Products.DeleteAllOnSubmit(r);
db.SubmitChanges();
GridView1.DataSource = r;
GridView1.DataBind();
Transaction.Current.Rollback();
}
}
protected void NewOrder_Click(object sender, EventArgs e)
{
NorthwindDataContext db = new NorthwindDataContext();
Product chai = db.Products.Single(p => p.ProductName == "Chai");
Product tofu = db.Products.Single(p => p.ProductName == "Tofu");
Order o = new Order();
o.OrderDate = DateTime.Now;
o.RequiredDate = DateTime.Now.AddDays(-2);
o.Freight = 4.30m;
Order_Detail li1 = new Order_Detail() { Product = chai, Quantity = 23 };
Order_Detail li2 = new Order_Detail() { Product = tofu, Quantity = 33 };
o.Order_Details.Add(li1);
o.Order_Details.Add(li2);
Customer c = db.Customers.Single(asdf => asdf.CompanyName.StartsWith("Alfred"));
c.Orders.Add(o);
db.SubmitChanges();
}
