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.ComponentModel.DataAnnotations;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;    

​

    // https://stackoverflow.com/questions/45979552/deserialize-json-from-a-sharepoint-2013-search-result-into-a-list-of-myclass

    public class MyClass

    {

        public long Id { get; set; } // This should be long not int

        public string Url { get; set; }

        public string Title { get; set; }

        public DateTime MyDate { get; set; }

    }

​

    public class KeyValuePropertyArrayConverter<T> : JsonConverter

    {

        public override bool CanConvert(Type objectType)

        {

            return typeof(T).IsAssignableFrom(objectType);

        }

​

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

        {

            if (reader.TokenType == JsonToken.Null)

                return null;

            var pairs = serializer.Deserialize<List<KeyValuePair<string, JToken>>>(reader);

            var jObj = new JObject(pairs.Select(p => new JProperty(p.Key, p.Value)));

            existingValue = existingValue ?? serializer.ContractResolver.ResolveContract(objectType).DefaultCreator();

            serializer.Populate(jObj.CreateReader(), existingValue);

            return existingValue;

        }

​

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

        {

            throw new NotImplementedException();

        }

    }

​

    class TestClass

    {

        public static void Test()

        {

            var jsonString = GetJson();

​

            // Disable date recognition while parsing intermediate JToken representation as shown in

            // https://stackoverflow.com/questions/35138346/jtoken-get-raw-original-json-value/35141787

            var item = JsonConvert.DeserializeObject<JObject>(jsonString, new JsonSerializerSettings { DateParseHandling = DateParseHandling.None });

​

            var finalSettings = new JsonSerializerSettings

            {

                Converters = { new KeyValuePropertyArrayConverter<MyClass>() /*, Add some appropriate IsoDateTimeConverter if required, */ },

                // Or set DateFormatString if required

            };

            var myClass = item["Cells"]["results"].ToObject<MyClass>(JsonSerializer.CreateDefault(finalSettings));

​

            Console.WriteLine("Re-serialized {0}", myClass);

            Console.WriteLine(JsonConvert.SerializeObject(myClass, Formatting.Indented));

            Assert.IsTrue(myClass.Id == 358553 && myClass.Url == "http://somewhere.com" && myClass.Title == "/Date(1234656000000)/");

        }

        static string GetJson()

        {

            var json = @"{

  ""__metadata"": {

    ""type"": ""SP.SimpleDataRow""

  },

  ""Cells"": {

    ""results"": [

      {

        ""__metadata"": {

          ""type"": ""SP.KeyValue""

        },

        ""Key"": ""Id"",

        ""Value"": ""358553"",

        ""ValueType"": ""Edm.Int64""

      },

      {

        ""__metadata"": {

          ""type"": ""SP.KeyValue""

        },

        ""Key"": ""Url"",

        ""Value"": ""http://somewhere.com"",

        ""ValueType"": ""Edm.String""

      },

      {

        ""__metadata"": {

          ""type"": ""SP.KeyValue""

        },

        ""Key"": ""Title"",

        ""Value"": ""\/Date(1234656000000)\/"",

        ""ValueType"": ""Edm.String""

      },

      {

        ""__metadata"": {

          ""type"": ""SP.KeyValue""

        },

        ""Key"": ""MyDate"",

        ""Value"": ""2017-09-10T11:10:19Z"",

        ""ValueType"": ""Edm.DateTime""

      }

    ]

  }

}";

            return json;

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: " + Environment.Version);

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

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine("Failed with unhandled exception: ");

                Console.WriteLine(ex);

                throw;

            }

        }

    }

​

    public class AssertionFailedException : System.Exception

    {

        public AssertionFailedException() : base() { }

​

        public AssertionFailedException(string s) : base(s) { }

    }

​

    public static class Assert

    {

        public static void IsTrue(bool value)

        {

            IsTrue(value, "failed");

        }

​

        public static void IsTrue(bool value, string message)

        {

            if (value == false)

                throw new AssertionFailedException(message ?? "failed");

        }

    }

​