title: linq after groupby unable to get column values
body: <p>I am getting data from multiple tables by joining and i want to group data on particular column value but after group by statement i can access my aliases and their properties. What mistake i am making?</p>
  
  <pre><code>public List&lt;PatientHistory&gt; GetPatientHistory(long prid)
  {
      using(var db = new bc_limsEntities())
      {
          List&lt;PatientHistory&gt; result = 
              (from r in db.dc_tresult
               join t in db.dc_tp_test on r.testid equals t.TestId into x
               from t in x.DefaultIfEmpty()
               join a in db.dc_tp_attributes on r.attributeid equals a.AttributeId into y
               from a in y.DefaultIfEmpty()
               where r.prid == prid
               group new {r,t,a} by new {r.testid} into g
               select new PatientHistory
               {
                   resultid = r.resultid,
                   bookingid = r.bookingid,
                   testid = r.testid,
                   prid = r.prid,
                   attributeid = r.attributeid,
                   result = r.result,
                   Test_Name = t.Test_Name,
                   Attribute_Name = a.Attribute_Name,
                   enteredon = r.enteredon,
                   Attribute_Type = a.Attribute_Type
               }).ToList();
          return result;
      }
  }
  </code></pre>