title: LinQ query with multiple tables and extracting data
body: <p>I'm doing a query to inner join 4 tables and I have to extract data and convert into string and place it in an array for it.</p>
  
  <pre><code>    var query = from a in context.as
                              join b in context.bs on a.prikey equals b.forkey
                              join c in context.cs on b.prikey equals c.forkey
                              join d in context.ds on c.prikey equals d.forkey
                              where b.gender == gender
                              where c.age == age
                              select new
                              {
                                  a.Name,
                                  a.Age,
                                  b.Gender,
                              };
  string[] results = new string[] {}
  return results;
  </code></pre>
  
  <p>Normally, if a single table is involved
  a as = plural of table a </p>
  
  <pre><code>as t = query.First() 
  string[] results = new string[] {t.Name, t.Age, t.Gender}
  return results;
  </code></pre>
  
  <p>I'm missing a step to extract the data. </p>