Working with SharePoint Lists though Client Object Model

How to get SharePoint List Items through SharePoint Client Object Model

• Iterate List Items

ClientContext clientContext = new ClientContext("Site URL");  
 NetworkCredential Cred = new NetworkCredential("UserName", "Password", "Domain");  
 clientContext.Credentials = Cred;  
 Web web = clientContext.Web;  
  Microsoft.SharePoint.Client.List lst = clientContext.Web.Lists.GetByTitle("List Name");  
   ListCollection fieldList = web.Lists;  
       clientContext.Load(fieldList);  
       // Execute the query to the server.  
       clientContext.ExecuteQuery();  
       foreach (Microsoft.SharePoint.Client.List lstobj in fieldList)  
       {  
         Console.WriteLine("\n"+"Title:" + lstobj.Title);  
         Console.WriteLine("Description:" + lstobj.Description);  
         Console.WriteLine("Created:" + lstobj.Created);  
         Console.WriteLine("\n");  
       }  
       Console.ReadLine();  

• SharePoint List Item count

ClientContext clientContext = new ClientContext("Site URL");  
 NetworkCredential Cred = new NetworkCredential("UserName", "Password", "Domain");  
 clientContext.Credentials = Cred;  
 Web web = clientContext.Web;  
  Microsoft.SharePoint.Client.List lst = clientContext.Web.Lists.GetByTitle("List Name");  
       clientContext.Load(lst);  
       clientContext.ExecuteQuery();  
       int cnt = lst.ItemCount; 
       Console.WriteLine(cnt);  
       Console.ReadLine();  

How to get SharePoint List Content Type Through CSOM - Client Object Model

How to get Content Type of particular list.

Code:

ClientContext clientContext = new ClientContext("Site URL");  
 String strPassword = "Password";  
 var passWord = new SecureString();  
 foreach (var c in strPassword.ToCharArray()) passWord.AppendChar(c);  
 NetworkCredential Cred = new NetworkCredential("Username", passWord, "Domain");  
 clientContext.Credentials = Cred;  
  ContentTypeCollection contentTypeColl = clientContext.Web.Lists.GetByTitle("ContetType Name").ContentTypes;  
       clientContext.Load(contentTypeColl);  
       clientContext.ExecuteQuery();  
       //// Display the Content Type name  
       foreach (ContentType ct in contentTypeColl)  
       {  
         Console.WriteLine(ct.Name);  
       }  
       Console.ReadLine();  

How to access Web Site through SharePoint Client Object Model

You can access WebSite  Properties through SharePoint Client Object Model.

Microsoft.SharePoint.Client should be use.

Code: 

ClientContext clientContext = new ClientContext("Site URL");

NetworkCredential Cred = new NetworkCredential("UserName", "Password", "Domain");

clientContext.Credentials = Cred;

Web web = clientContext.Web;

clientContext.Load(web);

clientContext.ExecuteQuery();

Console.WriteLine("Title:" + web.Title);

Console.WriteLine("Description:" + web.Description);

Console.WriteLine("Created:" + web.Created);

onsole.ReadLine();

If you want to access only specific properties from WebSite, it can be achieved using LINQ.

Code:

ClientContext clientContext = new ClientContext("Site URL");

NetworkCredential Cred = new NetworkCredential("UserName", "Password", "Domain");

clientContext.Credentials = Cred;

Web web = clientContext.Web;

clientContext.Load(web, a => web.Title,

                        a => web.Description,

                        a => web.Created);clientContext.ExecuteQuery();

Console.WriteLine("Title:" + web.Title);

Console.WriteLine("Description:" + web.Description);

Console.WriteLine("Created:" + web.Created);

onsole.ReadLine();