title: joining a table with more than one field in same table
body: <p>I try to create a join query in Linq. I want to join a table more than one field with same </p>
  
  <p>table. Please see my code below.</p>
  
  <pre><code>var roles = (from ords in _orderRepository.Table 
                           join customers in _customerRepository.Table on ords.CustomerId equals customers.Id
                           join ordprvrnts in _orderProductVariantRepository.Table on ords.Id equals ordprvrnts.OrderId
                           join prdvrnts in _productVariantRepository .Table on ordprvrnts.ProductVariantId equals prdvrnts.Id
                           **join cstevntrle in _customerEventRoleRepository.Table on 
                               new{  customers.Id equals cstevntrle.CustomerId } &amp;&amp; 
                               new { cstevntrle.EventId == model.Event}**
                           orderby customers.Email ascending
                           select new CustomerEventRolesModel
                           {
  
                               Customer = customers.Email,
                               CUstomerId =customers.Id
  
                           });
  </code></pre>
  
  <p>I try to filter customerEventRoleRepository.Table with CustomerId and  EventId</p>
  
  <p>how can i do this in this join query.</p>
  
  <p>Please Help.</p>