title: Asp.net/SQL - Retrieving data from multiple tables using foreign keys
body: <p>I'm new to ASP.NET and SQL, and I'm trying to build a Web Forms project that will basically display data using grids. </p>
  
  <p>I'm using Entity Framework along with a Data Transfer Object and a Data Access Layer for displaying/editing data.</p>
  
  <p>My issue is that I'm not sure what is the best way of retrieving data using foreign keys.</p>
  
  <p>Example:</p>
  
  <p><strong>Table 1 - Products</strong></p>
  
  <pre><code>|(PK) Product ID | Product Name | Country ID(FK)
  </code></pre>
  
  <p><strong>Table 2 - Countries</strong></p>
  
  <pre><code>|(PK) Country ID | Country Name|
  </code></pre>
  
  <p><strong>Final Result Should be:</strong></p>
  
  <pre><code>Product ID | Product Name | Country Name|
  </code></pre>
  
  <p>What's the best way to accomplish that?</p>
  
  <p>Thanks in advance</p>