title: using equal and not equal in a linq join
body: <p>I am trying to convert following SQL query to linq;</p>
  
  <pre><code>select Or.Amount, Usr.Name, Usr.Email
  from [order] as Or
  left join vw_AllUsers as Usr on Usr.UserId = Or.UserId and Usr.RoleName &lt;&gt; 'Admin'
  </code></pre>
  
  <p>I couldn't find a way to use <strong>equal</strong> and <strong>not equal</strong> in the same join..
  If <strong>Usr.RoleName &lt;> 'Admin'</strong> was <strong>Usr.RoleName = 'Admin'</strong>, the linq statement could be written like that </p>
  
  <pre><code>var result =  from Or in context.orders
                join Usr in context.vw_AllUsers on 
                new { userid = Or.UserId, role = "Admin"}
                equals
                new { userid = Usr.UserId, role = Usr.RoleName}
                select ........
  </code></pre>
  
  <p>or i can handle it in where part of the linq to get same result, as follows</p>
  
  <pre><code>where !Usr.RoleName.Equals("Admin")
  </code></pre>
  
  <p>but is it possible to handle this in join part of the linq ?</p>
  
  <p>Thanks in advance</p>