Convert Json array of objects to most suitable .Net collection

Question

I have the following Json collection and I need to represent it as a .Net collection. Esentially it is a key-value pair list with the keys (col) possibly having dublicates (dictionary is out at this stage).

I sorting and grouping would be nice but not essential. Can any help identify what the best .Net enumeration would be the best fit please?

[
    {
        "col": "thiscol",
        "val": "thisval"
    },
    {
        "col": "thiscol",
        "val": "thisval2"
    },
    {
        "col": "thiscol2",
        "val": "thisval2"
    },
    {
        "col": "thiscol3",
        "val": "thisval3"
    }
]

L.B · Accepted Answer · 2012-04-10 22:14:24Z

13

using Json.Net

dynamic dynObj = JsonConvert.DeserializeObject(yourstring);
foreach (var item in dynObj)
{
    Console.WriteLine(item.col + " " + item.val);
}

or

JArray jArray = (JArray)JsonConvert.DeserializeObject(yourstring);
var newlist = jArray.OrderByDescending(x => x["val"]).ToArray();

or

JArray jArray = (JArray)JsonConvert.DeserializeObject(yourstring);
dynamic dynObj1 = jArray.OrderByDescending(x => x["val"]);
foreach (var item in dynObj1)
{
    Console.WriteLine(item.col + " " + item.val);
}

or with built-in JavaScriptSerializer & dynamic

dynamic dynObj2 = new JavaScriptSerializer().Deserialize<List<object>>(yourstring);
foreach (var item in dynObj2)
{
    Console.WriteLine(item["col"] + " " + item["val"]);
}

edited Apr 10, 2012 at 22:14

answered Apr 10, 2012 at 21:23

L.B

116k20 gold badges189 silver badges229 bronze badges

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

Comments

BrokenGlass · Accepted Answer · 2012-04-10 21:18:09Z

1

You can use a lookup in this case, basically a dictionary that allows multiple values for each key - with Linq you can project to a lookup using ToLookup(). Note that lookups are immutable though - that might not fit your bill.

Alternatively of course you can just use a Dictionary<T,IList<U>> (or IEnumerable<U>) using a collection as your value type - dictionaries are flexible like that.

answered Apr 10, 2012 at 21:18

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

Comments

SouthShoreAK · Accepted Answer · 2012-04-10 21:20:03Z

1

IEnumerable<YourObject> where YourObject is a class you define to hold these values. I recommend using Json.Net to parse the json. Then you can just use linq to manage the IEnumerable you get back.

answered Apr 10, 2012 at 21:20

SouthShoreAK

4,3162 gold badges30 silver badges50 bronze badges

Comments

Satish · Accepted Answer · 2012-04-10 21:29:34Z

1

Have you looked at NameValueCollection?

answered Apr 10, 2012 at 21:29

Satish

3,1107 gold badges35 silver badges47 bronze badges

Comments

Dirk · Accepted Answer · 2014-03-11 10:37:46Z

0

JArray arr = JArray.Parse(Your string);

After that using for loop to get the values,

edited Mar 11, 2014 at 10:37

Dirk

11k2 gold badges38 silver badges50 bronze badges

answered Mar 11, 2014 at 10:19

vinothkanniappan A

11 bronze badge

Collectives™ on Stack Overflow

Convert Json array of objects to most suitable .Net collection

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related