public static IQueryable <ListItem> QueryProjects(this ListItemCollection collection) { return(collection.Include(project => project.Id, project => project["Title"], project => project["Technology"], project => project["ProjectLink"], project => project["ProjectLinkText"])); }
private IEnumerable <ListItem> LoadItems(List list, string viewXml, List <string> viewFields, params Expression <Func <ListItem, object> >[] properties) { // Used to resolve 'the query expression is not supported' error loading item with FieldValues... // http://www.manvir.net/invalidqueryexpressionexception-the-query-expression-is-not-supported/ CamlQuery query = new CamlQuery(); query.ViewXml = viewXml; ListItemCollection items = list.GetItems(query); List <Expression <Func <ListItem, object> > > listItemExpressions = new List <Expression <Func <ListItem, object> > >(properties); foreach (string viewField in viewFields) { Expression <Func <ListItem, object> > retrieveFiedlDataExpresion = item => item[viewField]; listItemExpressions.Add(retrieveFiedlDataExpresion); } IEnumerable <ListItem> resultData = list.Context.LoadQuery(items.Include(listItemExpressions.ToArray())); list.Context.ExecuteQuery(); return(resultData); }
public static IQueryable <ListItem> QuerySkills(this ListItemCollection collection) { return(collection.Include(highlight => highlight.Id, highlight => highlight["SkillName"], highlight => highlight["SkillLevel"])); }
public static IQueryable <ListItem> QueryHighlights(this ListItemCollection collection) { return(collection.Include(highlight => highlight.Id, highlight => highlight["Title"], highlight => highlight["Text"])); }