title: LinqToSql - Include linked object in selected result
body: <p>I have two tables. Linked with a foreign key.</p>
  
  <p><a href="https://i.stack.imgur.com/VmKfO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VmKfO.jpg" alt="linked tables"></a>
  </p>
  
  <p>Now I fetch a row from the field table:</p>
  
  <pre><code>IField Field = from f in DataContext.fields
                 where f.mapId == mapId &amp;&amp; f.x1 == x &amp;&amp; f.y1 == y
                 select f;
  </code></pre>
  
  <p>Working with this row I need some data from the linked table fieldViews. So I just do somthing like this:</p>
  
  <pre><code>[..] Field.FieldViews [..]
  </code></pre>
  
  <p>According to the SQL Profiler Linq To Sql generates the following queries.</p>
  
  <pre><code>SELECT
      [t0].[fieldId],
      [t0].[mapId],
      [t0].[x1],
      [t0].[y1]
  FROM
      [dbo].[fields] AS [t0]
  WHERE 
      ([t0].[mapId] = @p0) AND 
      ([t0].[x1] = @p1) AND 
      ([t0].[y1] = @p2)
  
  
  SELECT
      [t0].[fieldViewId],
      [t0].[fieldId],
      [t0].[mapUserId]
  FROM
      [dbo].[fieldViews] AS [t0]
  WHERE
      [t0].[fieldId] = @p0
  </code></pre>
  
  <p><strong>But I don't want 2 queries.</strong> How can I make LinqToSql to include this linked object within the first query?</p>