SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to get all items from a single list (getting specific fields) without using a CamlQuery? If I try to use context.Load(oList, ...), I can't use the Include method as the List class doesn't implement the Include method.

I've seen examples that use a ListCollection, but I'm only using one list.

share|improve this question
do you want to get all list items with specific fields? not returning the fields but rather the items themselfs? – ali Sharepoint Mar 12 '13 at 13:59
Yes, the items, but only with certain columns/fields. – PeterX Mar 13 '13 at 1:39

If I'm not wrong you can use empty CamlQuery.

CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<View/>";

For performance issue the common practice is to use view fields to reduce response data.

camlQuery.ViewXml = 
          <FieldRef Name='PartLookup' LookupId='TRUE' />
          <FieldRef Name='PartLookupSKU' />
          <FieldRef Name='PartLookupTitle' />
          <FieldRef Name='PartLookupDescription' />
          <FieldRef Name='BinNumber' />
          <FieldRef Name='Quantity' />
share|improve this answer
Yes, so it seems you can't avoid the CamlQuery when fetching specific fields? – PeterX Mar 13 '13 at 1:39
I think - yes :) – Alexander Mar 13 '13 at 8:08
Don't forget about the CreateAllItemsQuery static function on the CamlQuery object:… – Cameron Verhelst Mar 14 '14 at 9:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.