ViewBag Does not render its values

Question

Can some tell me why this ViewBag does not want to render its values?

ViewBag.fields = from f in db.Fields
                    where f.FieldId == id
                    select new { name = f.Name, id = f.FieldId };

@foreach(var item in  ViewBag.fields)
{
@item.name//error, cannot find the definition of name
}

And i tried also this.

@foreach(var item in  ViewBag.fields)
{
@item[0]//error, 'object' does not contain a definition for 'name'
}

However, if do this

@foreach(var item in ViewBag.fields)
{
@item 
}

it render

{name = Document, id=1}

What do i have to do?

Are you certain that there is actually data returned by the query? — Erik Funkenbusch, May 03 '13 at 16:32
yes, when i write just the @item it renders {name = document, id = 1} — , May 03 '13 at 16:33
Have you tried converting the query results to a List via .ToList()? — Erik Funkenbusch, May 03 '13 at 16:36
Because, your IQueryable is probably linked to a datacontext that is destroyed after it goes out of scope. — Erik Funkenbusch, May 03 '13 at 16:38
Other duplicate: http://stackoverflow.com/questions/8980045/storing-an-anonymous-object-in-viewbag — nemesv, May 03 '13 at 16:48

Erik Funkenbusch · Answer 1 · 2013-05-03T18:35:38.797

1

nemesv's link explains why this doesn't work, you basically are forced to create a named type rather than using an anonymous type. You could use Tuple, but you would have to convert the results to an IEnumerable first because Linq to Entities can't use constructor parameters.

So either create a type to transfer the data or do this:

ViewBag.fields = (from f in db.Fields
                where f.FieldId == id
                select new { name = f.Name, id = f.FieldId })
                .AsEnumerable()
                .Select(x => new Tuple<string, int>(x.name, x.id);

Then in view

@foreach(var item in ViewBag.fields)
{
    item.Item1
}

edited May 03 '13 at 18:35

answered May 03 '13 at 16:43

Erik Funkenbusch

92,674
28
195
291

How this would help? fields is still dynamic which causes the problem together with the anonymous object. – nemesv May 03 '13 at 16:46
@nemesv - Although the problem isn't because of dynamic, you are correct. I used a different tact. – Erik Funkenbusch May 03 '13 at 17:08
with the tuple you need to reference the "name" field with `@item.item1` – nemesv May 03 '13 at 17:13

ViewBag Does not render its values

1 Answers1