lambda query printing curly braces '{' in result

Question

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

arun prasath · Answer

change it as follow: var q = db.table1.Where(n => n.user== USER).Select(n => new { Name=n.NameLastName= n.LastName }).ToList(); and try it

Vulpes · Answer

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;