using System;

using System.Data;  

using System.Xml;

using System.IO;

public class Program

{

    // relates to http://stackoverflow.com/questions/44044927/c-sharp-datatable-binary-serialization

    public static void Main()

    {

        var data = new System.Data.DataTable("data");

        data.Columns.Add("Id", typeof(int));

        data.Columns.Add("Value", typeof(string));

        for (var i = 0; i < 100; i++)

        {

            var row = data.NewRow();

            row["Id"] = i;

            row["Value"] = "DataBlob" + i;

            data.Rows.Add(row);

        }

        var data2 = new System.Data.DataTable("data2");

        data2.Columns.Add("Id", typeof(int));

        data2.Columns.Add("Description", typeof(string));

        for (var i = 0; i < 100; i++)

        {

            var row = data2.NewRow();

            row["Id"] = i;

            row["Description"] = "Data Description " + i;

            data2.Rows.Add(row);

        }

        System.Data.DataTable[] tables = new System.Data.DataTable[] { data, data2 };

        SaveToFile(tables, "datatable.data");

        //saving to xml

        System.Data.DataSet set = new System.Data.DataSet();

        set.Tables.Add(data);

        set.Tables.Add(data2);

        set.WriteXml("datatable.xml");

        Console.WriteLine("datatable.data File Size:" + new FileInfo("datatable.data").Length + " Bytes");

        Console.WriteLine("datatable.xml File Size:" + new FileInfo("datatable.xml").Length + " Bytes");

        System.Data.DataTable[] result = LoadFromFile("datatable.data");

        var isSameusing System;

using System.Data;  

using System.Xml;

using System.IO;

public class Program

{

    // relates to http://stackoverflow.com/questions/44044927/c-sharp-datatable-binary-serialization

    public static void Main()

    {

        var data = new System.Data.DataTable("data");

        data.Columns.Add("Id", typeof(int));

        data.Columns.Add("Value", typeof(string));

        for (var i = 0; i < 100; i++)

        {

            var row = data.NewRow();

            row["Id"] = i;

            row["Value"] = "DataBlob" + i;

            data.Rows.Add(row);

        }

        var data2 = new System.Data.DataTable("data2");

        data2.Columns.Add("Id", typeof(int));

        data2.Columns.Add("Description", typeof(string));

        for (var i = 0; i < 100; i++)

        {

            var row = data2.NewRow();

            row["Id"] = i;

            row["Description"] = "Data Description " + i;

            data2.Rows.Add(row);

        }

        System.Data.DataTable[] tables = new System.Data.DataTable[] { data, data2 };

        SaveToFile(tables, "datatable.data");

        //saving to xml

        System.Data.DataSet set = new System.Data.DataSet();

        set.Tables.Add(data);

        set.Tables.Add(data2);

        set.WriteXml("datatable.xml");

        using System;

using System.Data;  

using System.Xml;

using System.IO;

public class Program

{

    // relates to http://stackoverflow.com/questions/44044927/c-sharp-datatable-binary-serialization

    public static void Main()

    {

        var data = new System.Data.DataTable("data");

        data.Columns.Add("Id", typeof(int));

        data.Columns.Add("Value", typeof(string));

        for (var i = 0; i < 100; i++)

        {

            var row = data.NewRow();

            row["Id"] = i;

            row["Value"] = "DataBlob" + i;

            data.Rows.Add(row);

        }

        var data2 = new System.Data.DataTable("data2");

        data2.Columns.Add("Id", typeof(int));

        data2.Columns.Add("Description", typeof(string));

        for (var i = 0; i < 100; i++)

        {

            var row = data2.NewRow();

            row["Id"] = i;

            row["Description"] = "Data Description " + i;

            data2.Rows.Add(row);

        }

        System.Data.DataTable[] tables = new System.Data.DataTable[] { data, data2 };

        SaveToFile(tables, "datatable.data");

        //saving to xml

        System.Data.DataSet set = new System.Data.DataSet();

        set.Tables.Add(data);

        set.Tables.Add(data2);

        set.WriteXml("datatable.xml");

        Console.WriteLine("datatable.data File Size:" + new FileInfo("datatable.data").Length + " Bytes");

        Console.WriteLine("datatable.xml File Size:" + new FileInfo("datatable.xml").Length + " Bytes");

        System.Data.DataTable[] result = LoadFromFile("datatable.data");

        var isSame

        Console.WriteLine("datatable.data File Size:" + new FileInfo("datatable.data").Length + " Bytes");

        Console.WriteLine("datatable.xml File Size:" + new FileInfo("datatable.xml").Length + " Bytes");

        System.Data.DataTable[] result = LoadFromFile("datatable.data");

        var isSame = true;

        for (var i=0;i<data.Rows.Count;i++)

        {

            if (data.Rows[i]["Id"].ToString() != result[0].Rows[i]["Id"].ToString() ||

               data.Rows[i]["Value"].ToString()!= result[0].Rows[i]["Value"].ToString())

            {

                isSame = false;

                Console.WriteLine("Data 1 Not Same Expected:" + data.Rows[i]["Id"].ToString() + " but was:" + result[0].Rows[i]["Id"].ToString());

                Console.WriteLine("Data 1 Not Same Expected:" + data.Rows[i]["Value"].ToString() + " but was:" + result[0].Rows[i]["Value"].ToString());

                break;

            }

        }

        for (var i = 0; i < data2.Rows.Count; i++)

        {

            if (data2.Rows[i]["Id"].ToString()!= result[1].Rows[i]["Id"].ToString() ||

               data2.Rows[i]["Description"].ToString()!= result[1].Rows[i]["Description"].ToString())

            {

                isSame = false;

                Console.WriteLine("Data 2 Not Same Expected:" + data2.Rows[i]["Id"] + " but was:" + result[1].Rows[i]["Id"]);

                Console.WriteLine("Data 2 Not Same Expected:" + data2.Rows[i]["Description"] + " but was:" + result[1].Rows[i]["Description"]);

                break;

            }

        }

        if (isSame)

        {

            Console.WriteLine("Same");

        }

        else            

        {

            Console.WriteLine("Not Same");

        }

    }

    public static bool SaveToFile(DataTable[] NW, string path)

    {

        try

        {

            using (var stream = new System.IO.MemoryStream())

            {

                System.Runtime.Serialization.IFormatter formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();

                formatter.Serialize(stream, NW);

                stream.Close();

                System.IO.File.WriteAllBytes(path, stream.ToArray());

            }

            return true;

        }

        catch (Exception ex)

        {

            return false;

        }

    }

    public static DataTable[] LoadFromFile(string path)

    {

        try

        {

            byte[] buffer = System.IO.File.ReadAllBytes(path);

            var stream = new System.IO.MemoryStream(buffer);

            System.Runtime.Serialization.IFormatter formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();

            return (DataTable[])formatter.Deserialize(stream);

        }

        catch (Exception ex)

        {

            return null;

        }

    }

}