#Visual basic data table to json object code#

In this article, we learned about different methods to convert DataTable to JSON and investigated how these methods perform on example data of different sizes.I have found JSON.NET to be good selection for working with JSON, examine the LINQ method shows better timings as the size of the data increases but it uses the most memory in all examples.Īnd in the end, a bit of a mediocre performance of the method puts it in last place. The speed drops as the data size increases, but the memory usage is even better than we get with JSON.NET. Based on this, we can conclude it is the best choice for this task.Ī bit surprisingly, the performance we get from the StringBuilder method is only slightly worse.

#Visual basic data table to json object code#

Wanna join Code Maze Team, help us produce more awesome. Public class Benchmark_1000000 : BenchmarkĭataTable = GenerateDummyDataTable(1000000) įirst, let’s see the performance on a DataTable with 1,000 records: Public class Benchmark_100000 : BenchmarkĭataTable = GenerateDummyDataTable(100000) Since we want to test our methods against a DataTable of different sizes, we will define additional classes that inherit the main Benchmark class but generate test data of different sizes: public class Benchmark_10000 : BenchmarkĭataTable = GenerateDummyDataTable(10000)

Public void StringBuilder() => Methods.DataTableStringBuilder(dataTable)

Public void Linq() => Methods.DataTableLinq(dataTable) Public void SystemTextJson() => Methods.DataTableSystemTextJson(dataTable) Public void NewtonsoftJsonNet() => Methods.DataTableNewtonsoftJsonNet(dataTable) Now we can create the methods we will use to perform benchmarking: Var jsonStringBuilder = new StringBuilder() The first one uses StringBuilder: public static string DataTableStringBuilder(DataTable dataTable) Let’s examine a more “manual” approach to this problem that revolves around the idea of composing a JSON string on our own.įor this, we will define two methods.

Now we can use JsonSerializer on this new structure to get the resulting JSON string. Return .Serialize(data) Īlthough DataTable serialization is not supported, with a bit of the LINQ magic, we can convert DataTable to a list of KeyValue objects. ToDictionary(col => col.ColumnName, c => row)) We can still make use of it with a small workaround: public static string DataTableSystemTextJson(DataTable dataTable) Unlike JSON.NET, the native library does not support DataTable conversion out-of-the-box. We can see it is pretty straightforward to convert DataTable to JSON using the JsonConvert class which is defined in the Newtonsoft.Json namespace. So, we can implement a method that takes advantage of this: public static string DataTableNewtonsoftJsonNet(DataTable dataTable)