How to convert a JSON array string to a dictionary?

Question

I have a JSON string which looks like:

[{"Id":"1","Name":"Apple "},{"Id":"2","Name":"Orange "},{"Id":"3","Name":"Banana "}....]

How can I convert the JSON string to this format: {"1":"Apple"},{"2":"Orange"},{"3","Banana"}... so I can create dictionary like:

Dictionary<string, string> d = new Dictionary<string, string>()
    {
        {"1":"Apple"},{"2":"Orange"},{"3","Banana"}
    };

Czech out JSON.NET and this post: http://stackoverflow.com/questions/1207731/how-can-i-deserialize-json-to-a-simple-dictionarystring-string-in-asp-net — B. Clay Shannon-B. Crow Raven, Dec 11 '15 at 17:37
Perhaps this can steer you in the right direction. http://stackoverflow.com/questions/30384599/deserialize-json-array-of-dictionaries-in-c-sharp — hawkstrider, Dec 11 '15 at 17:38

score 1 · Answer 1 · answered Dec 11 '15 at 17:59

1

You don't need to actually transform your original string to another format.

With the use of an intermediary class, as shown below, you can convert directly:

using Newtonsoft.Json;
using System.Linq;

Dictionary<string, string> tt = JsonConvert.DeserializeObject<List<DataObject>>(@"[{""Id"":""1"",""Name"":""Apple ""},{""Id"":""2"",""Name"":""Orange ""},{""Id"":""3"",""Name"":""Banana ""}]").ToDictionary(k => k.Id, v => v.Name);

public class DataObject
{
    public string Id { get; set; }
    public string Name { get; set; }
}

So what this does is first convert the Json array into a List<DataObject>, and then using the Linq ToDictionary operator we complete the job.

Hope this helps

answered Dec 11 '15 at 17:59

Luc Morin

5,302
20
39

Remove @ in the given string otherwise it will encountered parsing issue. – Pankaj Gupta Dec 12 '15 at 05:51
@PankajGupta care to elaborate ? – Luc Morin Dec 13 '15 at 05:41
i agree i gave wrong answer but when you use single quotes instead og using this ""id"" so we don't need to use @ . – Pankaj Gupta Dec 13 '15 at 07:17

How to convert a JSON array string to a dictionary?

1 Answers1