By using this snipet you can read any of list in SharePoint.Am reading SharePoint calender list using CAML query .
MsOnlineClaimsHelper claimsHelper = new MsOnlineClaimsHelper("url",
"username", "password");
using (ClientContext context = new ClientContext("https://sitename.sharepoint.com"))
{
context.ExecutingWebRequest += claimsHelper.clientContext_ExecutingWebRequest;
context.Load(context.Web);
context.ExecuteQuery();
Web oWebsite = context.Web;
MsOnlineClaimsHelper claimsHelper = new MsOnlineClaimsHelper("url",
"username", "password");
using (ClientContext context = new ClientContext("https://sitename.sharepoint.com"))
{
context.ExecutingWebRequest += claimsHelper.clientContext_ExecutingWebRequest;
context.Load(context.Web);
context.ExecuteQuery();
Web oWebsite = context.Web;
}
context.Load(oWebsite, website => website.Webs, website => website.Title);
context.ExecuteQuery();
Console.WriteLine("Available sites Count: " + oWebsite.Webs.Count);
for (int i = 0; i != oWebsite.Webs.Count; i++)
{
Console.WriteLine("Site Title: " + oWebsite.Webs[i].Title);
ListCollection collList = oWebsite.Webs[i].Lists;
context.Load(collList);
context.ExecuteQuery();
foreach (List oList in collList)
{
Console.WriteLine("Title: {0} Created: {1}", oList.Title, oList.Created.ToString());
if (oList.Title == "Calendar")
{
CamlQuery query = new CamlQuery();
query.ViewXml = "<View><Query><OrderBy><FieldRef Name='Created' Ascending='True'></FieldRef></OrderBy></Query></View>";
ListItemCollection ItemsColl = oList.GetItems(query);
context.Load(ItemsColl);
context.ExecuteQuery();
}
}
}
