SharePoint SDKを使用して C#でドキュメント管理を行なう方法

using System;
using System.Text;
using Microsoft.SharePoint.Client;

namespace SharePointTest1
{
    class Program
    {
        static void Main(string[] args)
        {
            // Starting with ClientContext, the constructor requires a URL
            // to the server running SharePoint.
            ClientContext context = new ClientContext("http://SiteUrl");

            // The SharePoint web at the URL.
            Web web = context.Web;

            // We want to retrieve the web's properties.
            context.Load(web);

            // Execute the query to the server.
            context.ExecuteQuery();

            // Now, the web's properties are available and we could display
            // web properties, such as title.
            System.Console.WriteLine("SharePoint Web Title: " + web.Title);
            System.Console.ReadLine();
        }
    }
}

using System;
using System.Text;
using System.Linq;
using Microsoft.SharePoint.Client;

namespace SharePointTest2
{
    class Program
    {
        static void Main(string[] args)
        {
            // Starting with ClientContext, the constructor requires a URL to the
            // server running SharePoint.
            ClientContext context = new ClientContext("http://SiteUrl");

            // The SharePoint web at the URL.
            Web web = context.Web;

            // Retrieve all lists from the server.
            // For each list, retrieve Title and Id.
            context.Load(web.Lists,
                         lists => lists.Include(list => list.Title,
                                                list => list.Id));

            // Execute query.
            context.ExecuteQuery();

            // Enumerate the web.Lists.
            foreach (List list in web.Lists)
            {
                System.Console.WriteLine("SharePoint List Title: " + list.Title);
            }

            System.Console.ReadLine();
        }
    }
}

using System;
using System.Text;
using System.Linq;
using Microsoft.SharePoint.Client;
using Microsoft.SharePoint.Client.QueryExpression;

namespace SharePointTest3
{
    class Program
    {
        static void Main(string[] args)
        {
            // Starting with ClientContext, the constructor requires a URL to the
            // server running SharePoint.
            ClientContext context = new ClientContext("http://SiteUrl");

            // Assume the web has a list named "Announcements".
            List announcementsList = context.Web.Lists.GetByTitle("Announcements");

            // This creates a CamlQuery that has a RowLimit of 100,
            //  and also specifies Scope="RecursiveAll"
            // so that it grabs all list items, regardless of the folder they are in.
            CamlQuery query = CamlQuery.CreateAllItemsQuery(100);
            ListItemCollection items = announcementsList.GetItems(query);

            // Retrieve all items in the ListItemCollection from List.GetItems(Query).
            context.Load(items);
            context.ExecuteQuery();
            foreach (ListItem listItem in items)
            {
                // We have all the list item data. For example, Title.
                System.Console.WriteLine("SharePoint ListItem Title: " + listItem["Title"]);
            }

            System.Console.ReadLine();
        }
    }
}

　listItem["ID"]          DBで言う所のレコード ID
　listItem["Title"]       コンテンツのタイトル
　listItem["FSObjType"]   コンテンツの種類 0=ファイル、1=ディレクトリ
　listItem["FileRef"]     コンテンツのフルパス "/hoge/xxxx/yyyy/zzzz.txt"
　listItem["FileDirRef"]  親ディレクトリ "/hoge/xxxx/yyyy"
　listItem["FileLeafRef"] ファイル名/ ディレクトリ名 "zzzz.txt"

Microsoft.SharePoint.Client
Microsoft.SharePoint.ClientRuntime
Microsoft.SharePoint.Client.UserProfiles

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint.Client;
using Microsoft.SharePoint.Client.UserProfiles;

namespace UserProfilesCSOM
{
    class Program
    {
        static void Main(string[] args)
        {
            // Replace the following placeholder values
            //  with the target SharePoint site and target user.
            const string serverUrl = "http://serverName/";
            const string targetUser = "domainName\\userName";

            // Connect to the client context.
            ClientContext clientContext = new ClientContext(serverUrl);

            // Get the PeopleManager object
            //  and then get the target user's properties.
            PeopleManager peopleManager = new PeopleManager(clientContext);
            PersonProperties personProperties = peopleManager.GetPropertiesFor(targetUser);

            // Load the request and run it on the server.
            // This example requests only the AccountName and UserProfileProperties
            // properties of the personProperties object.
            clientContext.Load(personProperties, p => p.AccountName,
                p => p.UserProfileProperties);
            clientContext.ExecuteQuery();

            foreach (var property in personProperties.UserProfileProperties)
            {
                Console.WriteLine(string.Format("{0}: {1}",
                    property.Key.ToString(), property.Value.ToString()));
            }
            Console.ReadKey(false);

            // TODO: Add error handling and input validation.
        }
    }
}