title: alternate of join in OData Service using linq
body: <p>I want to join two tables in LINQ, my query is some thing like</p>
  
  <pre><code>SELECT        mfg.MfgName
  FROM            MasterProductStaging AS mps INNER JOIN
                           Mfg AS mfg ON mps.MfgID = mfg.MfgID
  WHERE        (mps.MasterProductStagingID = 345345)
  </code></pre>
  
  <p>Now in LINQ, I solve this problem using two different queries</p>
  
  <pre><code>    var test = (from d in DataContext.MasterProductStagings
                                          where d.MasterProductStagingID == Convert.ToInt32(Request.QueryString["MPSID"])
                                          select d.MfgID).FirstOrDefault();
  
  var data = (from d in DataContext.Mfgs
                                          where d.MfgID == test.ToString()
                                          select d).FirstOrDefault();
  </code></pre>
  
  <p>The tables doesn't have any relation in <code>emdx</code> Model.
  Now I to get my desired data in a single query.</p>