title: LINQ to SQL LoadWith Mutilple Joins
body: <p>I have the following table structure....</p>
  
  <ul>
  <li>Pilots</li>
  <li>Operators</li>
  <li>Ranks</li>
  </ul>
  
  <p>Pilots/Operations - there are multiple pilots to one operator.</p>
  
  <p>Ranks: 1) Captain 2) First Officer</p>
  
  <p>Each operator then defines its own rank criteria (hours required etc).</p>
  
  <p>So to get the actual name of the rank I need to join from Pilots -> Operators -> Ranks.</p>
  
  <p>I would like to do this with LoadWith e.g.</p>
  
  <pre><code>options.LoadWith&lt;Pilot&gt;(x =&gt; x.Operator);
  </code></pre>
  
  <p>How to now make it also eager load the ranks? The above statement only causes a join to Operators.</p>
  
  <p>Thanks.</p>