Serializing c# class to JSON string with custom column name

Question

I have this result

{
    "StatusCode": "200",
    "Description": "Success",
    "Data": [
        {
            "Language_Key": "btn_select_country",
            "En_Val": "SELECT COUNTRY",
            "Ar_Val": "اختر الدولة"
        },
        {
            "Language_Key": "btn_continue",
            "En_Val": "CONTINUE",
            "Ar_Val": "استمرار"
        }
      ]
}

I would like to achieve below result.

{
"StatusCode":"200",
"Description":"Success",
"Data":{
    "btn_select_country":{
          "En_Val":"SELECT COUNTRY",
          "Ar_Val":"اختر الدولة"
    },
    "btn_continue":{
          "En_Val":"CONTINUE",
          "Ar_Val":"استمرار"
    }
  }
}

I want Language_Key to replace with column name and with 2 child nodes as EN and AR below is my code

Any hint is appreciated. Thanks

Answer 1

you serialize a dictionary where the key is your Language_Key:

Dictionary<string, Translation> dict = countryObj
    .ToDictionary(o => o.Language_Key, o => new Translation { Ar_Val = o.Ar_Val, En_Val = o.En_Val});
    
rs.Data =  dict;
json = new JavScriptSerializer().Serialize(rs);

Answer 2

You can use JsonProperty Attribute to rename properties after they get serialize.

https://www.newtonsoft.com/json/help/html/JsonPropertyName.htm