title: linq to sql where not in
body: <p>I am trying find all the users that are not in a friends user friend list using linq to sql. Right now I am comparing friendslist to all the users in the system. Theres gotta be a better way of doing this using linq to sql. Thanks for any help</p>
  
  <pre><code>// Comparing this to list to see who does not exist.
  // What I would like to do is just use one statement
  // to get the list of non friend users
  var friends = (from x in db.FriendsLists
                 where
                     (x.TheUser == GlobalVariables.User.ID) ||
                     (x.TheFriend == GlobalVariables.User.ID)
                 select x).ToList();
  
  var allUsersInSystem = (from x in db.Users select x).ToList();
  </code></pre>