title: How to SELECT WHERE NOT EXIST using LINQ?
body: <p>I have to list all "<strong>shift</strong>" data to be assigned to an "<strong>employee</strong>" but shift data must not be included if it is already existing in employee's data. Let's see the image sample.  </p>
  
  <p><img src="https://i.stack.imgur.com/T2Sco.png" alt="No filtering yet"></p>
  
  <p>This query solves the problem. I found this here:<br>
  <a href="http://miniburb.wordpress.com/2007/05/31/sql-outer-join-vs-where-not-in-vs-not-exists/" rel="noreferrer">Scott's Blog</a>  </p>
  
  <pre><code>select * from shift where not exists 
  (select 1 from employeeshift where shift.shiftid = employeeshift.shiftid
  and employeeshift.empid = 57);  
  </code></pre>
  
  <p>Let's see the result:  </p>
  
  <p><img src="https://i.stack.imgur.com/STsh2.png" alt="Filtered">  </p>
  
  <p>Now my question is, how could I make this in linQ ? I'm using entity framework.<br>
  Hope someone could help. Thanks a lot!!!</p>