title: linq not in query
body: <p>I'm lost in linq-land, trying to turn this SQL (which give the results I need) into something that works in linq / C#. The result will end up in a SelectList.</p>
  
  <pre><code>select Agencies.AgencyName, Agencies.AgencyId
  from Agencies
  where Agencies.Active = 1 and Agencies.AgencyId not in (
    select distinct Agencies.AgencyId
    from Agencies, AgenciesDonors
    where AgenciesDonors.AgencyId = Agencies.AgencyId and
          AgenciesDonors.DonorId = '73B29E01-8BF0-4EC9-80CA-089BA341E93D')
  </code></pre>
  
  <p>The Guid value will be passed in each time.  </p>
  
  <p>Help very much appreciated after a long day of getting nowhere.</p>
  
  <p>EDIT:  I should have said I'm working in an MVC 1.0 / EF context.  Not sure how that changes the initial answers.</p>