ASP.NET C# System.Linq.Enumerable+WhereSelectEnumerable Error

Question

Getting this weird LINQ error.

title = System.Linq.Enumerable+WhereSelectEnumerableIterator`2[System.Xml.Linq.XElement,System.String

Here is the code I have:

if (Request.QueryString["Keywords"] != null){
        string keywords = Request.QueryString["Keywords"];
            string myAppID = "HIDDEN";
            var xml = XDocument.Load("http://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsByKeywords&SERVICE-VERSION=1.0.0&SECURITY-APPNAME=" + myAppID + "&RESPONSE-DATA-FORMAT=XML&REST-PAYLOAD&keywords=" + keywords + "&paginationInput.entriesPerPage=5");
            XNamespace ns = "http://www.ebay.com/marketplace/search/v1/services";
            var titles = from item in xml.Root.Descendants(ns + "title")
                              select new{
                                  title = xml.Descendants(ns + "title").Select (x => x.Value),
                              };
        foreach (var item in titles){
                Label1.Text += item;
            } 
        }

Here what the XML looks like:

<findItemsByKeywordsResponse xmlns="http://www.ebay.com/marketplace/search/v1/services">
<searchReslut count="5">
<item>
    <title></title>
</item>
<item>
    <title></title>
</item>
<item>
    <title></title>
</item>

Trying to get it to output correctly.

That doesn't look like an error message to me. Do you have the actual error message? — Robert Harvey, Jun 27 '12 at 15:36
debug doesn't show me any errors persay. and comma makes no difference. — allencoded, Jun 27 '12 at 15:39
@allencoded: Then you're going to need to be more specific about what your problem is. — Robert Harvey, Jun 27 '12 at 15:40
Just try change that line to `title = item.Value` - it seems obvious to me it's `ToString()` the collection you're selecting. EDIT: should post as answer, hold on. — Codesleuth, Jun 27 '12 at 15:41
Set a break point in debug and hover over "item" in your foreach loop. See if it's an object or a string. — Chris Gessler, Jun 27 '12 at 15:43

Codesleuth · Accepted Answer · 2012-06-27T16:08:06.903

3

Instead of

title = xml.Descendants(ns + "title").Select (x => x.Value)

change to

title = item.Value

EDIT as ChrisGessler suggests, but with my suggestion:

if (Request.QueryString["Keywords"] != null)
{
    string keywords = Request.QueryString["Keywords"];
    string myAppID = "HIDDEN";
    var xml = XDocument.Load(/* snip */);
    XNamespace ns = "http://www.ebay.com/marketplace/search/v1/services";
    var titles = xml.Root.Descendants(ns + "title").Select(x => x.Value);
    Label1.Text = String.Join(null, titles);
}

edited Jun 27 '12 at 16:08

answered Jun 27 '12 at 15:43

Codesleuth

10,321
8
51
71

Couldn't the select new part be removed as well? select item.Value – Chris Gessler Jun 27 '12 at 15:48
Well if we were to look at the question as a challenge for optimization, then sure we could pull it apart and get much cleaner code. My answer was only to solve OP's problem, but feel free to post an answer with a rework :) – Codesleuth Jun 27 '12 at 15:50
question? How can I output it a array? – allencoded Jun 27 '12 at 23:51
In the example I wrote, you can see that `xml.Root.Descendants(ns + "title").Select(x => x.Value)` returns an `IEnumerable`, which you can simply do `.ToArray()` to get an array. So: `titles.ToArray()` – Codesleuth Jun 28 '12 at 09:28

Chris Gessler · Answer 2 · 2012-06-27T16:12:05.640

1

I'm thinking this:

var titles = from item in xml.Root.Descendants(ns + "title")                               
             select new{                                   
                title = xml.Descendants(ns + "title").Select (x => x.Value)};

Should be:

var titles = from item in xml.Root.Descendants(ns + "title")                               
             select item.Value);

edited Jun 27 '12 at 16:12

answered Jun 27 '12 at 15:55

Chris Gessler

22,727
7
57
83

score 0 · Answer 3 · answered Nov 28 '17 at 17:54

quick snippet

.. as example when using mvc grid in a cshtml razor page..

..

 .RenderValueAs(
       item => @Html.ActionLink(
        (
         from tsrItem in (item.<yourColumnName>) 
         where tsrItem.<IdField> == item.<IdField> 
         select tsrItem.<desiredColumn>
        ).FirstOrDefault(),

.. hope it helps

ASP.NET C# System.Linq.Enumerable+WhereSelectEnumerable Error

3 Answers3