title: Get linq to return IEnumerable<DataRow> result
body: <p>How can I convert following SQL query to LINQ in C#?</p>
  
  <p>I don't need all columns from both tables and the result set should be </p>
  
  <pre><code>IEnumerable&lt;DataRow&gt;
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>select 
      c.level, cl.name, c.quantity
  from 
      dbo.vw_categories c
  left join 
      dbo.vw_categoriesLocalization cl on c.level = cl.level 
                                       and cl.language = 'en'
  where 
      c.level like '000%' 
      and c.level &lt;&gt; '000';
  </code></pre>
  
  <p>Expected:</p>
  
  <pre><code>IEnumerable&lt;DataRow&gt; result = ????
  </code></pre>
  
  <p>Thanks in advance..</p>