lambda query printing curly braces '{' in result

ceci bela

12y1.2k.NET

hi.

I got this query below that's printing rows with curly braces '{' in view. How can I fix that?

Lambda Query:

var q = db.table1.Where(n => n.user== USER).Select(n => new { n.Name, n.LastName }); 
ViewBag.test = q;

View:

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

Output:

{ Name = john, LastName=Smith} { Name = Mike, LastName=mojie}

Thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

arun prasath12y ago
change it as follow: var q = db.table1.Where(n => n.user== USER).Select(n => new { Name=n.Name,LastName= n.LastName }).ToList(); and try it
Vulpes12y ago
I'd try returning strings, formatted as you want, rather than anonymous types:

var q = db.table1.Where(n => n.user== USER)
.Select(n => String.Format("{0}, {1}", n.Name, n.LastName));
ViewBag.test = q;