12 May 2010

LINQ to SharePoint - code snippets

Get all Root Sub-folders from a list
using (SPSite site = new SPSite(""))
{
    using (SPWeb web = site.OpenWeb())
    {
        SPList lib = web.Lists[""];
        var folders = from SPFolder folder in lib.RootFolder.SubFolders
                        where folder.Name != "Forms"
                        orderby folder.Name
                        select new ListItem(folder.Name, web.Url + "/" + folder.Url);

        foreach (ListItem li in folders)
        {
            Response.Write(li.Text.ToString());
        }

    }
}

Get all Root sub-folders from a list and return as SPFolder
var folders = from SPFolder folder in lib.RootFolder.SubFolders
                where folder.Name != "Forms"
                orderby folder.Name
                select new { folder };

if (folders.Count() > 0)
{
    foreach (var varFolder in folders)
    {
        if (varFolder.folder.Name.Equals("abc"))
        {
            return varFolder.folder;
            
        }
    }
}

No comments:

Post a Comment