LINQ C# to Array JSON Object in MVC

Question

My intention is to use LINQ query then return JSON for MVC controller.

format I want to achieve:

[{ 
   "A" : {"Count": 2 },
   "B" : {"Count": 7 },
}]

or

[{ 
   "A" : [{"Count": 2 }],
   "B" : [{"Count": 7 }],
}]

But so far I only can make it like this:

[{ 
   {"MG":"A", "Count": 2 },
   {"MG":"B", "Count": 7 }
}]

And I try something like below, it get error

Invalid anonymous type member declarator. Anonymous type members must be declared with a member assignment, simple name or member access.

public JsonResult groupByTable()
{
    IQueryable<tblSAPMessage> v = sapMessages();
    var data = v.GroupBy(g => g.MaterialGroup)
        .Select(g => new { g.Key.ToString() = new {
                    Count = g.Count()
                }});
    return Json(data, JsonRequestBehavior.AllowGet);
}

Appreciate if someone can point me to correct direction. Thanks !

score 1 · Answer 1 · edited May 23 '17 at 11:58

1

if i understand correctly you need dynamic property names. You could achieve it only using Expando Object

You could try something around these lines.

dynamic mytype = new ExpandoObject();
var data = v.GroupBy(g => g.MaterialGroup)
        .Select(g => (IDictionary<string, object>) mytype.Add(g.Key.ToString(),
        new {Count =  g.Count()}));

you could look at these answers for more inspiration Dynamic properties

edited May 23 '17 at 11:58

Community

1
1

answered Jul 29 '16 at 06:47

Ashley John

2,379
2
21
36

I feel like I got your idea, but somehow, I play around with the code, still not able to make it. Still having same error. – Eric K. Jul 29 '16 at 07:01

score 0 · Answer 2 · answered Jul 29 '16 at 16:44

0

you can use json.net / newtonsoft to create a json object

using Json.net
var countObject = new JObject ();
countObject.Add("count",2);
var jsonObject = new JObject();
jsonObject.Add("a", countObject);

answered Jul 29 '16 at 16:44

michael berezin

1,146
7
8

Thanks Michael, yr method will need a loop, but i look for method using linq. – Eric K. Jul 30 '16 at 02:08
Have you tried using the linq foreach?https://msdn.microsoft.com/en-us/library/bwabdf9z(v=vs.110).aspx – michael berezin Jul 30 '16 at 16:56

LINQ C# to Array JSON Object in MVC

2 Answers2