title: linq query with or and operator together
body: <p>I need to run multiple conditions in linq query with or, and operator. First I need to compare with three conditions, which are separated by || operator, once one of the conditions is true I also need to see if check is true which I using &amp;&amp; operator but I got all the result</p>
  
  <p>so for example from following query, if ModuleLead == ContextSession.StaffID then record must have ClinicalSupervisorCheck == true</p>
  
  <pre><code>var query_b = (from b in activeAssessmentWithRemidiation
                  where b.AssessorID == ContextSession.StaffID 
                     || b.ModuleLead == ContextSession.StaffID 
                     &amp;&amp; b.ClinicalSupervisorCheck == true 
                     || b.SeniorStaffID == ContextSession.StaffID 
                     &amp;&amp; b.ModuleLeadCheck==true
                     select b).ToList();
  </code></pre>
  
  <p>the above query is running on following table records</p>
  
  <p><a href="https://i.stack.imgur.com/2okFi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2okFi.png" alt="enter image description here"></a></p>