title: Linq query to execute stored procedure with return type as DataTable
body: <p>I am trying to get result as <code>DataTable</code> from a stored procedure using a Linq query. Here is the code that I am trying to use:</p>
  
  <pre><code>_dbContext.Database.Sqlquery&lt;DataTable&gt;("dbo.uspGetOrdersDetails @orderID", orderParam);
  </code></pre>
  
  <p>but the result is empty </p>
  
  <p><img src="https://i.stack.imgur.com/LCmr6.png" alt="Screenshot with return type as DataTable"></p>
  
  <p>If I keep as viewmodel, then I am able to get the data</p>
  
  <p><img src="https://i.stack.imgur.com/dawst.png" alt="enter image description here"></p>
  
  <p>Just want to know that, is it possible with datatable.</p>