Sharepoint学习笔记---Linq to Sharepoint--增，删，改操作
首先在我们的测试网站创建一个名为MyProducts的List，定义三个Customer Column均为String类型。如图当然，你不用插入任何记录。
下面以此List为对象进行相应的增，删,改操作
1、添加操作
var dc = new NorthWindEntityDataContext(SPContext.Current.Web.Url);
EntityList<MyProductsItem> MyCustProducts;
MyCustProducts = dc.GetList<MyProductsItem>("MyProducts");
string ProductNameStr = "NewProductName";
MyProductsItem newProduct = new MyProductsItem();
newProduct.Title = "ATestPrd" + DateTime.Now.ToShortTimeString().Trim();
newProduct.ProductName = ProductNameStr;
newProduct.ProductPrice = "15";
dc.MyProducts.InsertOnSubmit(newProduct);
dc.SubmitChanges();
2、修改操作
var dc = new NorthWindEntityDataContext(SPContext.Current.Web.Url);
EntityList<MyProductsItem> MyCustProducts;
string ProductNameStr = "ModifiedProductName";
MyCustProducts = dc.GetList<MyProductsItem>("MyProducts");
var updateItem = (from p in MyCustProducts
where p.ProductName == ProductNameStr
select p).First();
updateItem.Title = "Updated" + ProductNameStr;
// Submit the changes
dc.SubmitChanges();
3、删除操作
var dc = new NorthWindEntityDataContext(SPContext.Current.Web.Url);
EntityList<MyProductsItem> MyCustProducts;
MyCustProducts = dc.GetList<MyProductsItem>("MyProducts");
string ProductNameStr = this.txtBxProductName.Text.ToString();
// Querying the list item that has to be deleted
var delItem = (from p in MyCustProducts
where p.ProductName == ProductNameStr
select p).First();
// Deleting the list item
MyCustProducts.DeleteOnSubmit(delItem);
// Submit the changes
dc.SubmitChanges();
页:
[1]