SerializableDataTable is a library providing an abstraction class that allows you to serialize and deserialize data to and from a DataTable instance.
Get Started
$ dotnet add package SerializableDataTableReadme
SerializableDataTable
SerializableDataTable is a library providing an abstraction class that allows you to serialize and deserialize data to and from a DataTable instance.
Help, Feedback, Contribute
If you have any issues or feedback, please file an issue here in Github. We'd love to have you help by contributing code for new features, optimization to the existing codebase, ideas for future releases, or fixes!
New in v1.0.x
- Initial release
- Added markdown support
Example
Refer to the Test project for exercising the library. This is example is using the NuGet package SerializationHelper for simplicity purposes.
using System.Data;
using SerializableDataTables;
using SerializationHelper;
// Create your DataTable and columns
DataTable dt1 = new DataTable("Test");
dt1.Columns.Add("id", typeof(int));
dt1.Columns.Add("name", typeof(String));
// Create your DataRows
dt1.Rows.Add(1, "Hello");
dt1.Rows.Add(2, "World");
SerializableDataTable sdt = SerializableDataTable.FromDataTable(dt);
string json = Serializer.SerializeJson(sdt, true);
Console.WriteLine("JSON: " + Environment.NewLine + json + Environment.NewLine);
/*
{
"Name": "Test",
"Columns": [
{
"Name": "id",
"Type": "Int32"
},
{
"Name": "name",
"Type": "String"
}
],
"Rows": [
{
"id": 1,
"name": "Hello"
},
{
"id": 2,
"name": "World"
}
]
}
*/
DataTable dt2 = Serializer.DeserializeJson<SerializableDataTable>(json).ToDataTable();