Namespace Workspace.XBR.Xperiflow.Utilities.AdoDataTable.Builder

Classes

DataTableBuilder

The DataTable Builder class is used to efficiently build a.NET DataTable by minimizing for loops required to build a final state DataTable.

Workspace.XBR.Xperiflow.Utilities.AdoDataTable.Builder.IDataTableModifier is used to generate additional columns (think additional Column Generator).

Workspace.XBR.Xperiflow.Utilities.AdoDataTable.Builder.IDataTableGenerator is used to generate datarows from a different data format (think DataRow generator).

Below is a code exmaple showing one of the ways to use the DataTable

// Get the Json Data from some API source or something
var metricsJson = NewtonSoft.Json.Linq.JObject columnDataJson = GetMetricsJsonDataTable();
...

// Initialize DataTableBuilder
DataTableBuilder datatableBuilder = new DataTableBuilder();

// Add Modifiers
datatableBuilder.AddModifier(si, new FormattedStringDataTableMod(si, "ModelStage", "ModelStageVerbose), StringFormatter.StringConverionTypes.SuperSpacedCase));

// Instantiate a DataTable
DataTable dtMetrics = new DataTable();

// Create the a IDataTableGenerator (in this case its the JsonDataTableGenerator)
JsonDataTableGenerator genJsonDataTable = new JsonDataTableGenerator(si, metricsJson);

// Build the DataTable from the DataTableGenerator and apply the Modifiers
dtMetrics = datatableBuilder.BuildFromDataTableGenerator(si, genJsonDataTable);

The JsonDataTableGenerator class is used to efficiently parse and generate a DataTable from a Pandas JsonDataTable. This class offers a variety of methods to work in tandem with the DataTableBuilder class to generate a DataTable