title: Entity Framework - how to join tables without LINQ and with only string?
body: <p>I have a question about Entity Framework. Please answer if you know answer on this. I have such query : </p>
  
  <pre><code>String queryRaw =
      "SELECT " +
      "p.ProductName AS ProductName " +
      "FROM ProductEntities.Products AS p " +
      "INNER JOIN CategoryEntities.Categories AS c " + 
      "ON p.CategoryID = c.CategoryID ";
  
  ObjectQuery&lt;DbDataRecord&gt; query = new ObjectQuery&lt;DbDataRecord&gt;(queryRaw, entityContext);
  
  GridView1.DataSource = query;
  GridView1.DataBind();
  </code></pre>
  
  <p>Particularly I want to join few tables in one query, but I can NOT use LINQ and can NOT use ObjectQuery with objects mapped to DB fields inside my query. Because each entity creates dynamically. So this is what i can NOT use : </p>
  
  <p>msdn.microsoft.com/en-us/library/bb425822.aspx#linqtosql_topic12</p>
  
  <p>msdn.microsoft.com/en-us/library/bb896339%28v=VS.90%29.aspx</p>
  
  <p><strong>The question is can I use something like this instead of using objects?</strong> </p>
  
  <pre><code>query.Join ("INNER JOIN CategoryEntities.Category ON p.CategoryID = c.CategoryID ");
  </code></pre>
  
  <p><strong>The purpose is to use Join method of ObjectQuery with syntax as in Where method :</strong> </p>
  
  <p>msdn.microsoft.com/en-us/library/bb338811%28v=VS.90%29.aspx</p>
  
  <p>Thanks, Artem</p>