title: LINQ query on birth date to get age
body: <p>I'm runing a query (in northwind db) on the employees birth date and I want to get their age. How do i do that?  </p>
  
  <pre><code>    private void Form1_Load(object sender, EventArgs e)
      {
          using (NorthWindDataContext dataContext = new NorthWindDataContext())
          {
              DateTime today = DateTime.Today;
  
              var q1 = from z in dataContext.Employees
                       select new
                       {
                           z.FirstName,
                         today-z.BirthDate &lt;---- problem  here
                       };
  
              dataGridView1.DataSource = q1;
  
          }
      }
  </code></pre>
  
  <p>in my final grid i want column of age.</p>
  
  <p>birthdate = 29/05/1969 (example)</p>