The property or field has not been initialized. It has not been requested or the request has not been executed

Question

I am getting this error and from what I understand this is when you try and access columns from the list item. I have tried various things including the line below:

clientContext.Load(items, eachItem => eachItem.Include(item => item,item => item["Name"]));

I started off using this code. All of these resulted in the same error message:

The property or field has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested

Here is my code that I'm currently using just to try and work out what is going on. The list I'm trying to access is a standard Picture Library, and I just need to the access the Name of the image so I can construct a url to the image.

        string server = "http://myserver/path/path";
        var context = new ClientContext(server);
        var web = context.Web;
        var list = web.Lists.GetByTitle("Photos");
        var listItemCollection = list.GetItems(CamlQuery.CreateAllItemsQuery());

        context.Load(listItemCollection);

        context.ExecuteQuery();

        foreach (ListItem listItem in listItemCollection)
        {
            Console.WriteLine(listItem.FieldValuesAsText["Name"]); // Also tried listItem.DisplayName and File.Name
        }

Answer 1

Try this:

Console.WriteLine(listItem["Title"]);

If you want to work with the DisplayName, you should do it like this:

ctx.Load(listItemCollection, items => items.IncludeWithDefaultProperties(item => item.DisplayName));

The following link should help you out: http://blogs.technet.com/b/speschka/archive/2009/11/01/using-the-sharepoint-2010-client-object-model-part-2.aspx