title: Need a LINQ code example to link two tables that have no foreign key
body: <p>I need a code example please for the following scenario.</p>
  
  <p>Suppose I have 2 tables, "Order" and "Supplier", and "Order" has a field called "SupplierId", and each Supplier has a "Town" field and you wanted to return all orders placed with suppliers who were located in "London", what would the LINQ look like. The tricky bit is that there is no foreign key, so no navigation properties.</p>
  
  <p>So</p>
  
  <pre><code>Order
    SupplierId
  
  
  Supplier
    Id
    City
  </code></pre>
  
  <p>Link is Supplier.Id == Order.SupplierId</p>
  
  <p>Condition is:
      Where Supplier.Town = "London"</p>
  
  <p>No foreign Key present between 2 tables.</p>
  
  <p>So what would the LINQ look like please to achieve the above?</p>
  
  <p>Many thanks.</p>