DateTime column type becomes String type after deserializing DataTable
The basic problem here is that Json.NET’s DataTableConverter infers each DataColumn.DataType by looking at token values present in the first row only. It works this way because it streams the JSON for the table in rather than loading the entirety into an intermediate JToken hierarchy. While streaming gives better performance with reduced memory use, it … Read more