CODEWITHSUNDEEP
c#json.net
Nick
Nick

Reputation: 1424

Generate JSON with nested objects keys

I'm trying to generate a JSON string in C# (.Net Core) from some database records.

Data schema is flat with category (string), book Id (integer) and book name (string).

Data rows look like:

Category    BookId    BookName
---------------------------------------
Mystery     1         My first book
Biography   2         My second book
Mystery     3         My third book
Crime       4         My fourth book
Romance     5         My fifth book
Biography   6         My sixth book
Mystery     7         My seventh book
Romance     8         My eight book
SciFi       9         My ninth book
Poetry      10        My tenth book

I'm running a simple SQL query to fetch the records (up-to 5000) in a C# List collection:

SELECT Category, BookId, BookName from Books

I want to generate a JSON string (preferably using Newtonsoft Json.Net library) with books grouped by category, and including the category and book-id as the nested object keys:

{
  "Mystery": {
    "1": {
      "Name": "My first book"
    },
    "3": {
      "Name": "My third book"
    },
    "7": {
      "Name": "My seventh book"
    }
  },
  "Biography": {
    "2": {
      "Name": "My second book"
    },
    "6": {
      "Name": "My sixth book"
    }
  },
  "Crime": {
    "4": {
      "Name": "My fourth book"
    }
  }
  :
  :
}

I've tried Dictionary and Lookup (probably better than Dictionary due to less overhead with hash operations), but I can't get them to generate the format I'm after mainly for direct key-based access in the JS object.

Any suggestions for a performant approach are appreciated.

Upvotes: 1

Views: 406

Answers (1)

Guru Stron
Guru Stron

Reputation: 141730

Try to convert your collection to nested dictionaries:

// use yor actual type here
var collection = new[] 
{
    new {Category = "Mystery", BookId = 1 , BookName = "My first book"},
    new {Category = "Mystery", BookId = 2 , BookName = "My second book"}
};

var res = collection
    .GroupBy(arg => arg.Category)
    .ToDictionary(g => g.Key, g => g.ToDictionary(b => b.BookId, b => b.BookName));
JsonConvert.SerializeObject(res, Newtonsoft.Json.Formatting.Indented);

Upvotes: 1

Related Questions