title: Getting data from foreign key table using LINQ
body: <p>I've 2 tables </p>
  
  <p>DeviceType Table </p>
  
  <pre><code>id   Name 
  1    Device Type 1
  2    Device Type 2
  </code></pre>
  
  <p>Device Table</p>
  
  <pre><code>id   Name     Device Type Id (fk)
  1    Device1  1
  2    Device2  1
  3    Device3  2
  </code></pre>
  
  <p>What I want is to query the data from device table with device type name using <code>LINQ Methods</code>. I couldn't find the <code>Include</code> method to use here. </p>
  
  <p>I'm trying to get this in result</p>
  
  <pre><code>id Name     DeviceType Name
  1  Device1  Device Type 1
  2  Device2  Device Type 1
  3  Device3  Device Type 2
  </code></pre>