title: Linq query to select data from table and join 2 tables
body: <p>I am trying to <code>select</code> everything from a table and then make a join with two other tables, from which I need just some of the columns. The final list will be populated into a <code>DevExpress GridControl</code>. The main table that I take the data from has these columns:</p>
  
  <pre><code>Id | ScheduleId | AccountId | Description
  </code></pre>
  
  <p>I can easily select everything from this table and return. Here is my list:</p>
  
  <pre><code>public IList&lt;StatusDescription&gt; getStatusDescription()
  {
      var listOfItems = from e in context.StatusDescription select e;
      return listOfItems.ToList&lt;StatusDescription&gt;();
  }
  </code></pre>
  
  <p>The other two tables are Schedules and Accounts, they look as follows:</p>
  
  <pre><code>Id | ScheduleName | DateFrom | DateTo
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Id | AccountName | AccountCode
  </code></pre>
  
  <p>I would like to join the <code>DateFrom</code> and <code>DateTo</code> from the <code>Schedule</code> table and the <code>AccountCode</code> from the <code>Account</code> table. Is it possible to get all that into a single list. I can easily bind it later to the <code>GridControl</code></p>