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 !

Community · Accepted Answer · 2017-05-23 11:58:59Z

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, 2017 at 11:58

CommunityBot

11 silver badge

answered Jul 29, 2016 at 6:47

Ashley John

2,4532 gold badges23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Eric K. Over a year ago

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.

michael berezin · Accepted Answer · 2016-07-29 16:44:42Z

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, 2016 at 16:44

michael berezin

1,2968 silver badges8 bronze badges

2 Comments

Eric K. Over a year ago

Thanks Michael, yr method will need a loop, but i look for method using linq.

michael berezin Over a year ago

Have you tried using the linq foreach?msdn.microsoft.com/en-us/library/bwabdf9z(v=vs.110).aspx

Collectives™ on Stack Overflow

LINQ C# to Array JSON Object in MVC

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related