title: how to insert a List object to sqlite?
body: <p>This is my class which helps me to deserialize json get result from api</p>
  
  <pre><code>public class STOCKS
      {
          public class RootObject  
          {
  
              [PrimaryKey] 
  
              public int sto_RECno { get; set; }
              public int sto_RECid_RECno { get; set; 
           }
  
        }
  
  </code></pre>
  
  <p>and this is my json deserialize operation.</p>
  
  <pre><code>var content = await _client.GetStringAsync("http://webapi/somewhere/");
  var StockLIST= JsonConvert.DeserializeObject&lt;List&lt;STOCKS.RootObject&gt;&gt;(content);
  
  </code></pre>
  
  <p>and i want to insert this data to my sqlite </p>
  
  <pre><code> conn = DependencyService.Get&lt;ISQLite&gt;().GetConnection(); 
                      conn.CreateTable&lt;STOCKS.RootObject&gt;();
   conn.Insert(StockLIST);
  </code></pre>
  
  <p>but it fails.</p>
  
  <p>i dont understand, where i m wrong.?
  my Stocks class contains nearly 90 variables. so i m looking for a appropriate solution to do it.</p>
  
  <p>should i convert the list to datatable or what?</p>
  
  <p>thank you for your help.</p>