Retrieve all the Document Library with folder and file count using SharePoint Client Object Model

Question

Hi Friends i have a SharePoint site having more Document Library's i just want to display this as a Console application using SharePoint Client Object Model.

thanks in advance

Answer 1

Following is the code to retrieve all document libraries with folders and file count.Hope it helps.

Console.WriteLine("Enter your user name (format: username@tenant.onmicrosoft.com)");
string userName = Console.ReadLine();
Console.WriteLine("Enter your password.");
SecureString password = GetPasswordFromConsoleInput();
using (ClientContext context = new ClientContext("Site Url"))
{
   context.Credentials = new SharePointOnlineCredentials(userName,password);
   Web web = context.Web;       
   var docLibs = context.LoadQuery(web.Lists.Where(l => l.BaseTemplate == 101));
   context.ExecuteQuery();

   foreach (var list in docLibs)
   {             
        Console.WriteLine(list.Title);
        context.Load(list.RootFolder.Folders);
        context.ExecuteQuery();
        foreach (Folder folder in list.RootFolder.Folders)
        {
          context.Load(folder.Files);
          context.ExecuteQuery();
          Console.WriteLine(folder.Name + "---- File count " + folder.Files.Count);
        }

     }
           Console.ReadLine();
}

Answer 2

It will return you all document library data in application.

 using (ClientContext clientContext = new ClientContext("Your Site URL "))
                {
                    List docList = clientContext.Web.Lists.GetByTitle("Document Library Name");
                    clientContext.Load(docList); CamlQuery camlQuery = new CamlQuery();
                    camlQuery.ViewXml = "<View Scope='RecursiveAll'></View>";
                    ListItemCollection listItems = docList.GetItems(camlQuery);
                    clientContext.Load(listItems);
                    clientContext.ExecuteQuery();
                    foreach (ListItem listItem in listItems)
                    Console.WriteLine("Id: {0} ", listItem.Id);
                }
                Console.ReadLine();