title: Entity Framework LINQ joining 5 tables on multiple columns (impossible?!)
body: <p>Please see image: <img src="https://i.stack.imgur.com/vK7kw.jpg" alt="enter image description here"></p>
  
  <p>I am trying to create a LINQ query that combines 5 different tables on 1 to 3 different columns.  I am basically taking the examples of 2 tables and repeating the join sections for tables 3 through 5.  </p>
  
  <p>UPDATE: how do I get the following LINQ query to work?????</p>
  
  <pre><code>    var match = (from t1 in context.cKNA1
                   join t2 in context.cKNB1 on 
                          new { t1.KUNNR, t1.RowId } equals 
                          new { t2.KUNNR, t2.RowId }
                   join t3 in context.cKNVV on 
                          new { t2.KUNNR, t2.RowId } equals 
                          new { t3.KUNNR, t3.RowId }
                   join t4 in context.cKNVH on 
                          new { t3.KUNNR, t3.RowId } equals 
                          new { t4.KUNNR, t4.RowId }
          SELECT ....columns here....)
  </code></pre>
  
  <p>I can't find anything online where there are more than 3 tables <strong>*AND</strong> 2 or more columns.</p>