Get specific value from nested collections using LINQ

Question

I have a collection of "product" objects that each contain a collection of benefit objects. See below:

<Products>
        <Product ID="454">
            <ProductName>Economy</ProductName>
            <Benefits>
                <Benefit>
                    <Name>Medical</Name>
                    <Value>5000000</Value>
                    <Excess>100</Excess>
                </Benefit>
                <Benefit>
                    <Name>Emergency</Name>
                    <Value>350</Value>
                    <Excess>100</Excess>
                </Benefit>
        </Product>
</Products>

I'm trying to create a LINQ query to get the "Medical" benefit value for product "454":

<%: Model.Products.Where(x => x.ProductId == "454").SelectMany(p => p.Benefits).Where(b => b.Name == "Medical").Select(v => v.Value.ToString()) %>

However this just returns:

System.Linq.Enumerable+WhereSelectEnumerableIterator`2[Domain.Entities.Benefit,System.String]  System.Linq.Enumerable+WhereSelectEnumerableIterator`2[Domain.Entities.Benefit,System.String]  System.Linq.Enumerable+WhereSelectEnumerableIterator`2[Domain.Entities.Benefit,System.String]  System.Linq.Enumerable+WhereSelectEnumerableIterator`2[Domain.Entities.Benefit,System.String

How do I get it to return the actual value I'm after?

cjk · Accepted Answer · 2010-11-30 14:08:00Z

4

If you know there is only one (guaranteed) then add .Single() - if there might be none / some and you just want the first, add .FirstOrDefault() (will return null if there are no results)

answered Nov 30, 2010 at 14:08

cjk

46.6k9 gold badges83 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joshua Rodgers Over a year ago

If the collection might be empty also look into SingleOrDefault() or FirstOrDefault()

Dean Chalk · Accepted Answer · 2010-11-30 14:40:55Z

2

try this

Model.Products
    .Where(p => p.ID == 454)
    .SelectMany(p => p.Benefits)
    .Where(b => b.Name == "Medical")
    .Single()
    .Value.ToString();

answered Nov 30, 2010 at 14:40

Dean Chalk

20.5k6 gold badges66 silver badges95 bronze badges

Comments

Jenish Rabadiya · Accepted Answer · 2015-08-07 08:01:51Z

0

try this:

var val = employees.Where(p => p.ProductId == 454).FirstOrDefault().Benefits.Select(b => b.Value).FirstOrDefault();

or

var benefits_value = employees.Where(p => p.ProductId == 454).Single().Benefits.Select(b => b.Value).Single();

edited Aug 7, 2015 at 8:01

Jenish Rabadiya

6,7766 gold badges35 silver badges62 bronze badges

answered Nov 30, 2010 at 14:35

Sid C

672 bronze badges

Collectives™ on Stack Overflow

Get specific value from nested collections using LINQ

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related