title: Entity Framework foreign key relationship returns no data
body: <p>I have two tables <code>order</code> and <code>order_lines</code>. They both have primary/foreign key relationship. However, when I try to retrieve data, then I don't see any data from my navigational property.</p>
  
  <pre><code>[Table("order")]
  public class order : BaseModel
  {
      public order()
      {
          this.OrderLines = new List&lt;order_lines&gt;();
      }
  
      [Key]
      [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
      public int id { get; set; }
      public double? total { get; set; }
  
      public List&lt;order_lines&gt; OrderLines { get; set; }
  }
  
  [Table("order_lines")]
  public class order_lines : BaseModel
  {
      [Key]
      [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
      public int id { get; set; }
      public int? ordernum { get; set; }
      [MaxLength(1000)]
      public string sku { get; set; }
  
      [ForeignKey("id")]
      public order Order { get; set; }
  }
  </code></pre>
  
  <p>And I am using the Linq query shown below to obtain data. I would like to see <code>OrderLines</code> property populated, but it returns 0 count.</p>
  
  <pre><code>var data = (from o in Context.order
              select o).ToList();
  </code></pre>