title: LINQ - Where not exists
body: <p>What is the equivalent of following statement in LINQ:</p>
  
  <pre><code>Select t1.appname, t1.julianDte, t1.cat 
  From table1 t1 
  Where NOT EXISTS 
     ( Select * 
       from table t2 
       where t1.cat = t2.cat AND t2.julianDte &lt; t1.julianDte )
  </code></pre>