title: Filter a list of objects by comparing with another list of different objects
body: <p>I have the following 3 classes in my dbml file:</p>
  
  <pre><code>public class Player {
      public int PlayerID {get; set;}
      public string Name {get; set;}
   }
  
  public class PlayerItem {
      public int PlayerItemID {get; set;}
      public int PlayerID {get; set;}
      public int ItemID {get; set;}
  }
  </code></pre>
  
  <p>There is an association created between Player.ID and PlayerItem.PlayerID</p>
  
  <pre><code>Public Class CustomItem {
      public int ItemID {get; set;}
      public string ItemName {get; set;}
  }
  </code></pre>
  
  <p>Here's the setup: </p>
  
  <ol>
  <li>I have a list of Players - List<code>&lt;Player&gt;</code></li>
  <li>Each player has a Entityset child of type PlayerItem</li>
  <li>I have a list of Items - List<code>&lt;Item&gt;</code></li>
  </ol>
  
  <p>How can I select only those players that have at least one custom item in their list of PlayerItems?  This is basically matching ItemID in each Player's PlayerItems with the Item
  ID in CustomItem.  </p>
  
  <p>Ultimately, I'd like to have a simple list of players - List<code>&lt;Player&gt;</code> - to work with.</p>