OK, let's play with LINQ4SP again.
You can download Beta1, write a simple query, create a new list item and lookup fields. In the next part I'll show you how to delete an item from a list:
[TestMethod]
public void DeleteCreatedItems()
{
using (AwContext context = new AwContext())
{
var q = from subCategory in context.ProductSubcategory
where subCategory.Title == "new sub category"
select subCategory;
foreach (ProductSubcategory psubcat in q) psubcat.DeleteOnSubmit();
var p = from product in context.Product
where product.ProductNumber == "AA" ||
product.ProductNumber == "Double test" ||
product.ProductNumber == "Date test"
select product;
foreach (Product prod in p) prod.DeleteOnSubmit();
var z = from pc in context.ProductCategory
where pc.Title == "new product category"
select pc;
foreach (ProductCategory prodcat in z) prodcat.DeleteOnSubmit();
context.Submit();
}
}
Posted
05-25-2008 10:53 PM
by
Agnes Molnar