title: Joining multiple tables using Entity Framework
body: <p>i am trying to join 3 tables using EF but it throws an error saying </p>
  
  <pre><code>consider swaping conditions on either side of equals
  </code></pre>
  
  <p>can some one pls help</p>
  
  <pre><code> var billdata = from billtotal in context.billTotals
                                     join billcard in context.billClubcards
                                         on billtotal.OrderID equals billcard.OrderID
  
                                     join billtender in context.billTenders
                                         on billtender.OrderID equals billtotal.OrderID
  
  
                                     select billtotal;
  </code></pre>