title: Linq with entity framework
body: <p>I'm new to LINQ and Entity Framework and would appreciate some advice on the following scenario.</p>
  
  <p>I have a entity model with two tables.</p>
  
  <p>Travel_Request and Resource</p>
  
  <p><strong>Sample Fields</strong></p>
  
  <p>Travel_Request</p>
  
  <pre><code>Request_ID
  Resource_ID
  </code></pre>
  
  <p>Resource</p>
  
  <pre><code>Resource_ID
  Resource_Name
  </code></pre>
  
  <p>I would like to add the Resource_Name to the list when returning all the TRAVEL_REQUESTS</p>
  
  <p>Thanks in advance</p>