1: ClientContext context = ClientContext.Current;
2: Web web = context.Web;
3: String listName = "CommentsList";
4: ListCollection lists = web.Lists;
5: IEnumerable<List> resultLists = context.LoadQuery(lists.Where(list => list.RootFolder.Name == listName));
6: context.ExecuteQuery();
7: List commentsList = resultLists.FirstOrDefault();
8: if (commentsList != null)
9: { 10: CamlQuery camlQuery = new CamlQuery();
11: camlQuery.ViewXml = "<View><Query><Where><IsNotNull><FieldRef Name='City'/></IsNotNull></Where></Query></View>";
12: _comments = commentsList.GetItems(camlQuery);
13: context.Load(_comments,
14: items => items.Include(
15: item => item.Id,
16: item => item["Title"],
17: item => item["Date"],
18: item => item["City"]));
19:
20: ClientRequestSucceededEventHandler success = new ClientRequestSucceededEventHandler(SuccesHandler);
21: ClientRequestFailedEventHandler failure = new ClientRequestFailedEventHandler(FailureHandler);
22: context.ExecuteQueryAsync(success, failure);
23: }