using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Runtime.Serialization.Formatters;

using System.IO;

using System.Data;

using System.Xml.Serialization;

using System.Runtime.Serialization;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;        

​

    [JsonConverter(typeof(JsonValueListConverter))]

    public sealed class JsonValueList

    {

        public JsonValueList()

        {

            this.Values = new List<KeyValuePair<string, string>>();

        }

​

        public List<KeyValuePair<string, string>> Values { get; private set; }

    }

​

    class JsonValueListConverter : JsonConverter

    {

        public override bool CanConvert(Type objectType)

        {

            return typeof(JsonValueList).IsAssignableFrom(objectType);

        }

​

        public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)

        {

            if (reader.TokenType == JsonToken.Null)

                return null;

            var jsonValue = (existingValue as JsonValueList ?? new JsonValueList());

            if (reader.TokenType != JsonToken.StartObject)

                throw new JsonSerializationException("Invalid reader.TokenType " + reader.TokenType);

            while (reader.Read())

            {

                switch (reader.TokenType)

                {

                    case JsonToken.Comment:

                        break;

                    case JsonToken.PropertyName:

                        {

                            var key = reader.Value.ToString();

                            if (!reader.Read())

                                throw new JsonSerializationException(string.Format("Missing value at path: {0}", reader.Path));

                            var value = serializer.Deserialize<string>(reader);

                            jsonValue.Values.Add(new KeyValuePair<string, string>(key, value));

                        }

                        break;

                    case JsonToken.EndObject:

                        return jsonValue;

                    default:

                        throw new JsonSerializationException(string.Format("Unknown token {0} at path: {1} ", reader.TokenType, reader.Path));

                }

            }

            throw new JsonSerializationException(string.Format("Unclosed object at path: {0}", reader.Path));

        }

​

        public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)

        {

            var jsonValue = (JsonValueList)value;

            writer.WriteStartObject();

            foreach (var pair in jsonValue.Values)

            {

                writer.WritePropertyName(pair.Key);

                writer.WriteValue(pair.Value);

            }

            writer.WriteEndObject();

        }

    }

​

    // dotnetfiddle does not support data contract attributes, so I had to comment them out.

​

    //[DataContract]

    public class Update_DB

    {

        //[DataMember(Name = "appname", IsRequired = true)]

        public string appname { get; set; }

        //[DataMember]

        public string key { get; set; }

​

        //[DataMember(Name = "data", IsRequired = true)]

        public List<JsonValueList> data { get; set; }

​

        //[DataMember]

        public string updateId { get; set; }

        //[DataMember]

        public string updateTS { get; set; }

        //[DataMember]

        public string creationUser { get; set; }

    }

​

    class TestClass

    {

        static string GetJson()

        {

            var json = @"{

""appname"" : ""MyApp"",

""key"" : ""Test123"",

""data"" :[

  { ""data1"" : ""10551296"", ""data2"" : ""TrainingIns"", ""data3"" : ""Completed""}

  ,

  { ""connectorType"" : ""webserver-to-appserver"", ""sourceUri"" : ""data4"", ""destinationUri"" : ""data5"", ""rails"" : ""N"", ""data6"" : ""null"" }

  ,

  { ""groupId"" : ""group1"", ""failbackAction"" : ""null"", ""normal"" : ""null"", ""failoverAction"" : ""null"", ""failbackAction"" : ""null"", ""failoverAction"" : ""null"", ""artifactId"" : ""mywebserver"", ""normalState"" : ""null"" }

  ,

  { ""instanceId"" : ""10551296abc"" }]

,

""updateId"" : ""MyID"",

""updateTS"" : ""30-AUG-16 05.56.24.000000000 AM"" ,

""creationUser"" : ""APICall""

}";

            return json;

        }

​

        internal static void Test()

        {

            var jsonString = GetJson();

​

            Console.WriteLine("Original JSON: ");

            Console.WriteLine(jsonString);

            Console.WriteLine("");

​

            var collection = JsonConvert.DeserializeObject<Update_DB>(jsonString);

​

            var json2 = JsonConvert.SerializeObject(collection, Formatting.Indented);

​

            Console.WriteLine("Deserialized and re-serialized JSON: ");

​

            Console.WriteLine(json2);

            string x = JsonConvert.SerializeObject(collection.data);

            Console.WriteLine("\nResult of serializing collection.data: ");

            Console.WriteLine(x);

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Json.NET version: " + typeof(JsonSerializer).Assembly.FullName);

            TestClass.Test();

        }

    }

​