title: How to get two tables returned by stored procedure
body: <p>My method:</p>
  
  <pre class="lang-cs prettyprint-override"><code>[Function(Name = "get_values")]
  [ResultType(typeof(Values_Result))]
  public IMultipleResults getvaluesresult([Parameter(DbType = "Int")] System.Nullable&lt;int&gt; Id1, [Parameter(DbType = "VarChar(100)")] string Id2)
  {
      IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), Id1, Id2);
      return ((IMultipleResults)(result.ReturnValue));
  }
  </code></pre>
  
  <p>Method call:</p>
  
  <pre class="lang-cs prettyprint-override"><code>var resultValues = cont1.getvaluesresult(Convert.ToInt32(clsSession.id1), "101");
  var resultValuesList = resultValues.GetResult&lt;Values_Result&gt;().ToList&lt;Values_Result&gt;();
  
  if (resultValuesList != null &amp;&amp; resultValuesList.Count &gt; 0)
  {
      var dataTable = resultValuesList.ToDataTable();
      // performing some tasks
  }
  </code></pre>
  
  <p>My stored procedure looks like this:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE  PROCEDURE get_values
      (@Id2 VARCHAR(50),  
       @Id1 INT)
  AS                  
  BEGIN 
      DECLARE @temp TABLE (id INT)
  
      INSERT INTO @temp 
          (SELECT id FROM table1)
  
      SELECT * FROM table2
      SELECT * FROM @temp
  END
  </code></pre>
  
  <p>I want to know how to get the two returned tables from the stored procedure.</p>
  
  <p>I don't want to join the tables in the stored procedure as one</p>