title: Find project by Person Category
body: <p>I got 4 tables.</p>
  
  <p><strong>tblProject</strong></p>
  
  <pre><code>ProjID
  </code></pre>
  
  <p><strong>tblProjectPerson</strong></p>
  
  <pre><code>ProjID 
  
  PersID
  </code></pre>
  
  <p><strong>tblPerson</strong></p>
  
  <pre><code>PersID
  
  CateogryID
  </code></pre>
  
  <p><strong>tblCategory</strong></p>
  
  <pre><code>CategoryID
  
  Title
  </code></pre>
  
  <p>I'm trying to find all projects that have a person who is for example a project manager related to it. The problem i'm having is that my repeater returns the same project twice because i have 2 project managers related to it. What i want is that the repeater returns one project even though many project managers are related to it.</p>
  
  <p>Help would be much appreciated</p>
  
  <p>this is my Linq code:</p>
  
  <pre><code>string val = dropdown.selectedvalue;
  var data = new ModelContext();
  var p = from d in data.tblProjects
  join pp in data.tblProjectPersons on d.ProjID equals pp.ProjID
  where pp.tblPersons.CategoryID.Equals(Val) select d
  </code></pre>