title: How to get data from linq query using select
body: <p>I'm testing a simple LINQ select query and want to get two DateTime values from the table, but I'm doing something wrong here and need to know what I'm doing/thinking wrong?</p>
  
  <p>My query:</p>
  
  <pre><code>var test = from x in db.Projects where x.ID == 1 select x;
  </code></pre>
  
  <p>Then I try to get on of the values like this:</p>
  
  <pre><code>DateTime Date = test. ????? 
  </code></pre>
  
  <p>Here I thought I should get a suggestion from the Intellisense after the dot to pick the value from the column <code>StartDate</code> the table, but this isn't working.</p>