title: Using Distinct with Linq to SQL
body: <p>How would this query be changed from sql to linq?</p>
  
  <pre><code>category
  select distinct prodCategory from table4
  
  subcategory
  SELECT distinct [prodSubCat] FROM [table4] WHERE ([prodCategory] = @prodCategory)
  
  
  prodCategory    prodSubCat
  -------------------------------------
  Home            Cassette Receiver
  Home            Receiver
  Home            cd player
  Home            cd player
  Home            Receiver
  Car             dvd player
  Car             GPS 
  </code></pre>
  
  <p>Ex.</p>
  
  <p>My Goal is to get prodSubCat for prodCategory = "Car"</p>
  
  <pre><code>Car             dvd player
  Car             GPS
  </code></pre>