how to show a single value of column razor view

Question

here is my markup

    <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Select(s=>s.targetxyz.wcc)</td>
    <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Sum(s=>s.wcc.col1)</td>
   <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Sum(s=>s.wcc.col2)</td>
    <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Sum(s=>s.wcc.col3)</td>
    <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Sum(s=>s.wcc.col4)</td>
    <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Sum(s=>s.wcc.col5)</td>
    <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Sum(s=>s.wcc.col6)</td>
    <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Sum(s=>s.wcc.col7)</td>
    <td class="subtotal">@Model.Where(s=>s.wcc.xyz=="abc").Sum(s=>s.wcc.col8)</td>

</tr>

my query

var data =
             from b in re.wccs
             join t in re.targetxyz on b.xyz equals t.dname
             select new val { wcc = b, targetxyz = t };


        return View(data);

my error

System.Linq.Enumerable+WhereSelectEnumerableIterator`2[db.Models.val,System.Int32]

i can load all the columns with sum but at the place of select command i get this error.

why any suggestion?

In the first row, the output of the `Select(...)` is an enumerable, not a single object. — DavidG, Jul 20 '16 at 12:16

score 1 · Accepted Answer · edited May 23 '17 at 10:28

1

You will need to use First or Single to get that value, and possible some ordering on data (as not sure what you want to show here)

e.g.

    @Model.Where(s=>s.wcc.xyz=="abc").Select(s=>s.targetxyz.wcc).FirstOrDefault()

    @Model.Where(s=>s.wcc.xyz=="abc").Select(s=>s.targetxyz.wcc).SingleOrDefault()

read here for difference of single & first: LINQ Single vs First

edited May 23 '17 at 10:28

Community

1
1

answered Jul 20 '16 at 12:42

Rob C

818
1
12
26

how to show a single value of column razor view

1 Answers1