JSON to Dictionary C# .Net 2.0 Standard

Question

I am downloading a JSON in the following format (which I can not change):

[
    {"Id":183,"description":"blahblahblah"},
    {"Id":184,"description":"blehblehbleh"},
    {"Id":1000,"description":"and so on..."}
]

How can I convert it to became a Dictionary<string, string> like so:

{
{"blahblahblah", "183"},
{"blehblehbleh", "184"},
{"and so on...", "1000"}
}

?

I´m using C# .Net Standard 2.0 (maybe I can use .Net 4.x)

Typically people use a JSON deserializer for this. I'm most familiar with NewtonSoft, who have an example of what I think you're looking for here: newtonsoft.com/json/help/html/DeserializeDictionary.htm — sunero4
– sunero4, Commented Oct 23, 2019 at 13:35

Krishna Varma · Accepted Answer · 2019-10-24 08:40:47Z

2

I suggest, first convert your json to c# model using json2csharp

The model for your json looks like

public class KeyValue
{
    public int Id { get; set; }
    public string description { get; set; }
}

then use Newtonsoft.Json.JsonConvert.DeserializeObject to convert the json to object

var results = Newtonsoft.Json.JsonConvert.DeserializeObject<List<KeyValue>>(jsonString);

finally use foreach to move it to dictionary

Dictionary<int, string> keyValuePairs = new Dictionary<int, string>();
foreach (var keyvalue in results)
{
     keyValuePairs.Add(keyvalue.description, keyvalue.Id);
}

edited Oct 24, 2019 at 8:40

answered Oct 23, 2019 at 13:39

Krishna Varma

4,2802 gold badges12 silver badges27 bronze badges

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

Comments

RoadRunner · Accepted Answer · 2019-10-23 13:55:55Z

You could use Newtonsoft.Json to deserialize your JSON into a dictionary.

Firstly, make an Item class(or whatever other name of class you choose).

public class Item
{
    [JsonProperty("Id")]
    public int Id { get; set; }

    [JsonProperty("description")]
    public string Description { get; set; }
}

Secondly, deserialize your json using JsonConvert.DeserializeObject()and assign the key as Description and the value as Id using Enumerable.ToDictionary(). Additionally, since your data is a JSON array, you should deserialize to a IEnumerable<Item> to get the correct results.

var json = "[{ \"Id\":183,\"description\":\"blahblahblah\"},{ \"Id\":184,\"description\":\"blehblehbleh\"},{ \"Id\":1000,\"description\":\"and so on...\"}]";

var deserializedJsonDict = JsonConvert
    .DeserializeObject<IEnumerable<Item>>(json)
    .ToDictionary(entry => entry.Description, entry => entry.Id);

foreach (var entry in deserializedJsonDict)
{
    Console.WriteLine($"Key={entry.Key}, Value={entry.Value}");
}

Output keys and values of dictionary:

Key=blahblahblah, Value=183
Key=blehblehbleh, Value=184
Key=and so on..., Value=1000

Collectives™ on Stack Overflow

JSON to Dictionary C# .Net 2.0 Standard

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related