[C#.NET][Sharepoint 2010] LINQ 與 Sharepoint 2010

2010-05-18

6823
0
Sharepoint 2010
2013-08-16

這是一項新功能，Microsoft.SharePoint.Linq命名空間路徑為

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI

以往我們在讀取清單時有幾種做法

1.SPList 用 for each

2.SPList 用 SPQuery

3.SPList 用 DataTable

4.Web Service

以下有幾個簡單的範例

SPSite site = null;
SPWeb web = null;
private void button1_Click(object sender, EventArgs e)
{
    string btn = ((Button)(sender)).Text; 
    site = new SPSite("http://127.0.0.1");
    //
    Stopwatch sw = new Stopwatch();
    sw.Reset();
    sw.Start();
    //
    web = site.OpenWeb();
    SPList list = web.Lists["Districts"];
    switch (btn)
    {
        case "foreach":
            foreach (SPListItem item in list.Items)
            {
                listBox1.Items.Add(item["City"] + "\t" + item["District"]);
            }
            break;
        case "CAML":
            SPQuery query = new SPQuery();
            query.Query = "<Query><OrderBy><FieldRef Name='City' /></OrderBy></Query>";
            foreach (SPListItem item in list.GetItems(query))
            {
                listBox1.Items.Add(item["City"] + "\t" + item["District"]);
            }
            break;
        case "DataTable":
            query = new SPQuery();
            query.Query = "<Query><OrderBy><FieldRef Name='City' /></OrderBy></Query>";
            SPListItemCollection items = list.GetItems(query);
            DataTable dt = items.GetDataTable();
            foreach (DataRow row in dt.Rows)
            {
                listBox1.Items.Add(row["City"] + "\t" + row["District"]);
            }
            break;
    }
    sw.Stop();
    long tk = sw.ElapsedTicks;
    listBox1.Items.Add(btn + " 方法共花費" + tk.ToString() + " tk");
    site.Dispose();
    web.Dispose();
}