title: Retrieve multiple result sets from a stored procedure using ObjectContext
body: <p>I have a stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE uspGetData
     ...Parameter
  AS
     SELECT 'hello' AS 'HelloColumn'
  GO
  </code></pre>
  
  <p>and then I use <code>ObjectContext</code> to execute the stored procedure</p>
  
  <pre><code>((IOjbectContextAdapter)this).ObjectContext.ExecuteFunction&lt;HelloClass&gt;("uspGetData", .... Parameter);
  </code></pre>
  
  <p><code>HelloClass</code> just a data class</p>
  
  <pre><code>public class HelloClass
  {
      public string HelloColumn { ... }
  }
  </code></pre>
  
  <p>and I get the perfect result that I need</p>
  
  <p>but now I require to add another <code>SELECT</code> in the stored procedure like this </p>
  
  <pre><code>CREATE PROCEDURE uspGetData
     ...Parameter
  AS
     SELECT 'hello' AS 'HelloColumn'
     SELECT 'byebye' AS 'ByeColumn'
  GO
  </code></pre>
  
  <p>Of course in real environment is more complex and doesn't only do <code>SELECT something</code> </p>
  
  <p>Now I can't get the results that I require to,</p>
  
  <p>I tried to do base class on the <code>HelloClass</code></p>
  
  <pre><code>public class HelloClass : ByeClass
  { ... }
  </code></pre>
  
  <p>also I try to insert 2 Object set into the <code>ObjectContext</code> command</p>
  
  <pre><code>((IOjbectContextAdapter)this).ObjectContext.ExecuteFunction&lt;HelloClass,ByeClass&gt;...
  </code></pre>
  
  <p>Is there anyway to get both results set out of the stored procedure?</p>