title: need to retrieve result set of Join Query
body: <p>Need to retrieve result set of both tables but i am getting null value in it</p>
  
  <pre><code>var Items = from t1 in dbModal.Table1
              join t2 in dbModal.Table2 on t1.id equals t2.Id
              select new 
              { t1, t2.column };
  </code></pre>
  
  <p><strong>need to map above query like  this</strong></p>
  
  <pre><code>Select t1.*,t2.Column from T1
  join T2 on T1.id=T2.Id
  </code></pre>