title: Using Join with IQueryable LINQ
body: <p>I am trying to implement Inner join query on two tables opportunityProducts and Products where I am supposed to return Iqueryable element in my MVC web API service. But from below, I am not able to get result as it throws error for conversion.  </p>
  
  <pre><code>public IQueryable&lt;OpportunityProducts&gt; GetProductsByShipID(int id)
   {
     IQueryable&lt;OpportunityProducts&gt; oppProductss = 
                    from c in db.OpportunityProducts
                    from p in db.Products
                    where p.ProductID == c.ProductID
                    select new { c.Quantity,c.ProductDesc,c.RemainingQuantity, p.QtyInHand};
      return oppProductss;
    }
  </code></pre>