title: Using SQLite-Net Extensions and OneToMany relation
body: <p>I'm having difficulty trying to implement an SQLite-Extensions example for Windows Phone 8.1 that features a OneToMany relation. I'd really like to use this feature but I'm pulling my hair out trying to get it to work. Like in this <a href="https://stackoverflow.com/questions/23463849/sqlite-extension-is-not-working-as-expected">question</a>, when I try to use the <a href="https://bitbucket.org/twincoders/sqlite-net-extensions/overview" rel="nofollow noreferrer">provided example</a> for a Stocks table that has a List of Valuations:</p>
  
  <pre><code>public class Stock
  {
      [PrimaryKey, AutoIncrement]
      public int Id { get; set; }
      [MaxLength(8)]
      public string Symbol { get; set; }
  
      [OneToMany(CascadeOperations = CascadeOperation.All)]      // One to many relationship with Valuation
      public List&lt;Valuation&gt; Valuations { get; set; }
  }
  
  public class Valuation
  {
      [PrimaryKey, AutoIncrement]
      public int Id { get; set; }
  
      [ForeignKey(typeof(Stock))]     // Specify the foreign key
      public int StockId { get; set; }
      public DateTime Time { get; set; }
      public decimal Price { get; set; }
  
      [ManyToOne]      // Many to one relationship with Stock
      public Stock Stock { get; set; }
  }
  </code></pre>
  
  <p>and I try to create the table I get the error:</p>
  
  <blockquote>
    <p>An exception of type 'System.NotSupportedException' occurred in app_name.exe but was not handled in user code Additional information: Don't know about >System.Collections.Generic.List`1 [app_name.Model.modelName]</p>
  </blockquote>
  
  <p>I had initially included a NuGet package reference to sqlite-net as well as SQLiteNetExtensions-PCL but it was previously mentioned that this is due to the wrong version of sqlite-net being referenced. </p>
  
  <p>However I've tried downloading the source for sqlite-net and building this locally and it doesn't get referenced directly by SQLiteNetExtensions. </p>
  
  <p>I've included the source locally in my solution as well it doesn't seem to make a difference. Would anybody have any further suggestions? I haven't come across any downloadable example for this.</p>