title: LINQ Join with multiple AND conditions
body: <p>I want to join two entities in my MVC application for data Processing through the LINQ join.</p>
  
  <p>For that I am trying to write the query like,</p>
  
  <pre><code>from enumeration in db.Enumerations
  join cust in db.Customers on ( enumeration.Value equals cust.lkpStatus &amp;&amp;       
  enumeration.EnumerationTypeID.Contains('Cust')
  </code></pre>
  
  <p>But I am getting Problem with this Query, So please give me some suggestion on this.</p>