How to convert list of model Data to DataTable in .Net

Convert List to DataTable is easy and light using JSon library.

Step 1: install Json library from Nuget package

>Go to Visual Studio Tools

> Library package manager > Package manager console

PM> Install-Package Newtonsoft.Json -Version 9.0.1

Your Model:

    public class Company : IEquatable<Company>

    {

        public int id { get; set; }

        public string name { get; set; }

               

        public string address { get; set; }

               

        public string phone { get; set; }

        public string fax { get; set; }

       

        public string email { get; set; }

        public string website { get; set; }

     }

private DataTable LoadCompany()

{

  private Company company;

  company = CompanyManager.getInstance().LoadCompanyList();

          

 string json = Newtonsoft.Json.JsonConvert.SerializeObject(company);

          

 var token = JToken.Parse(json);

          

 if (token.Type == JTokenType.Object)

          

     token = new JArray(token);

        

  DataTable dt = token.ToObject<DataTable>();

return dt;

}