Reading and writing to Json

sudheer kumar

I have the following Json.

In the Json i want to read connectString and MetadataUrl in my C# app and write those values back to json with some other text.

{

"DBConnection": {

"connections": [

{

"connectString": "Server=(localdb)\\MSSQLLOCALDB;Initial Catalog=Test;",

"Region": "India",

}

},"Myapp": {

"RequestTimeoutAfterXHours": 24,

"TestIdSettings": [

{

"MetadataUrl": "http://localhost/Myapp/.well-known",

"Audience": "http://testurl.com"

}

]

"AllowedHosts": "*"

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Varun Setia6y ago
You need this type of structure, your main class will be JsonConfig.
public class Connection
    {
        public string connectionString { get; set; }

        public string region { get; set; }
    }

    public class DbConnection
    {
        public Connection[] connections { get; set; }
    }

    public class testIdSetting
    {
        public string MetadataUrl { get; set; }

        public string Audience { get; set; }
    }

    public class myApp
    {
        public int RequestTimeoutAfterXHours { get; set; }
        public testIdSetting[] testIdSettings { get; set; }
    }

    public class JsonConfig
    {
        public DbConnection DBConnection { get; set; }
        public myApp MyApp { get; set; }
        public string AllowedHosts { get; set; }
    }
To read the Json File you will write and update as per need
var configFile = JsonConvert.DeserializeObject(File.ReadAllText("path://exact-path"))
configFile.DBConnection.connections[0].connectionString = "new-value"; //example
configFile.MyApp.testIdSettings[0].MetadataUrl = "new-value"; //example
Now Write the file back to path
var jsonStr = JsonConvert.SerializeObject(configFile);
File.WriteAllText("path://exact-path", jsonStr);

Please let me know if this doesn't solve your problem.
Jenith Thakkar6y ago
Hi First convert your json to c# class
You can convert it from here

https://json2csharp.com/

Then deserialize that json and store all the value in class object
https://www.c-sharpcorner.com/article/json-serialization-and-deserialization-in-c-sharp/

Check this example of deserialization
Thank you