Convert Json to datatable from Linq Query results using serializeObject

You can use third party components Newtonsoft JSON to serializeObject to JSON and convert it into datatable. Just two line code will bring your solution first include Newtonsoft.Json namespace in your application and it will allow to use JsonConvertor class. The below example code has implemented.

You can download and install newtonsoft JSON package using NuGet package manager.

Install-Package Newtonsoft.Json

  string json = Newtonsoft.Json.JsonConvert.SerializeObject(result);  
  DataTable pDt = JsonConvert.DeserializeObject<DataTable>(json); 

Output: