using System;

using System.Collections.Generic;

using System.IO;

using System.Data;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Serialization;

using System.Xml;

//https://stackoverflow.com/questions/46158581/serializing-a-datatable-with-byte-column-to-json-generate-base64-string-but-w

​

public class Program

{

    public static void Main()

    {

        ITraceWriter traceWriter = new MemoryTraceWriter();

        try

        {

        Console.WriteLine("Deseriialize DataTable to Json with byte[]");

        var dt = GetDataTable();

        //show table structure

        Console.WriteLine("The Original datatable structure");

        DumpTableStructure(dt);

        var settings = new JsonSerializerSettings

                {

                   TypeNameHandling =TypeNameHandling.Objects,  

                    TraceWriter = traceWriter,

                    Formatting = Newtonsoft.Json.Formatting.Indented,

                }; 

        var json = JsonConvert.SerializeObject(dt, settings);

        Console.WriteLine(json);

        var dt2= JsonConvert.DeserializeObject<DataTable>(json, settings);

        Console.WriteLine("The generated datatable structure");

        DumpTableStructure(dt2);

        }       

        catch ( Exception ex)

        {

             Console.WriteLine("***** Json Trace******");

             Console.WriteLine(traceWriter);

             Console.WriteLine("***** Exception ******");

             Console.WriteLine("Deserialization to <DataTable> ,with TypeNameHandling.Objects, raise Exception: {0} ",ex.Message);

             Console.WriteLine("***** Exception details******");

             Console.WriteLine(ex);

        }

    }

    public static DataTable GetDataTable()

        {

            DataTable dataTable = new DataTable("table");

            dataTable.Columns.Add("f1", typeof(byte[]));

            dataTable.Columns.Add("f2", typeof(string));

            dataTable.Columns.Add("id", typeof(int));

​

            DataRow newRow = dataTable.NewRow();        

            newRow["f1"] =  new byte[]{0xE6,0x10, 0x00,0x24,0x40 };

            newRow["f2"] = "hi all";

            newRow["id"] = 1;

            dataTable.Rows.Add(newRow);

​

            newRow = dataTable.NewRow();

            newRow["f1"] = new byte[]{0xE6,0x1a, 0xf0,0x24,0x40 };

            newRow["f2"] = "hi world";

            newRow["id"] = 2;

            dataTable.Rows.Add(newRow);

            return dataTable;

        }

      public static  void DumpTableStructure(DataTable dt)

        {

            foreach (DataColumn column in dt.Columns)

            {

                Console.WriteLine("Name: {0} type: {1}", column.ColumnName, column.DataType);

            }

        }

}

​

​

​