title: linq to sql relationship
body: <p>I want to return a dataset with some relations, the query is OK but I get the ID instead of the real value from the other table... This is the query</p>
  
  <pre><code>        var thr=
              from u in dc.thresholds
              select u;
  </code></pre>
  
  <p>This returns something like this:</p>
  
  <pre><code>id: 1
  name: some name
  type_id: 1
  owner_id: 1
  </code></pre>
  
  <p>I want to get type_id and owner_id with the values of theese tables, so it can be something like:</p>
  
  <pre><code>id: 1
  name: some name
  type_id: Danger
  owner_id: John Smith
  </code></pre>
  
  <p>I hope some of you could give me some advices, I'm starting with LINQ to SQL and I'm a bit lost...</p>
  
  <p>Thank you</p>