Get more returns of a Stored Procedure (Linq to SQL)

Question

I created a Store Procedure to make tests for study its functionality.

my procedure execute two selects:

Example: Select TOP 20 * From NotaFiscal Select TOP 20 * From ProdutoNotaFiscal

Using the ADO.NET, the Dataset is filled with 2 results and generates 2 DataTables. Using Linq to SQL the type of return is a ISingleResult

I need to get the 2 returns of my procedure, but I'm not able to do that.

How can I get the result of 2 selects from procedure to LINQ?

Take a look here: http://stackoverflow.com/questions/371445/linq-to-sql-stored-procedures-with-multiple-results — R. Martinho Fernandes, Dec 17 '09 at 20:54

score 0 · Answer 1 · answered Dec 21 '09 at 04:50

You would need to create a partial class for your datacontext, and then add a method that wrap the result of your stored procedure and cast it to a IMultipleResults.

public partial class EntitiesDataContext
  {
    [Function(Name = "dbo.SPReturnMultipleResult")]
    [ResultType typeof(NotaFiscal)]
    [ResultType typeof(ProductoNotaFiscal)]
    public IMultipleResults SPReturnMultipleResult()
    {
      IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
      return ((IMultipleResults)(result.ReturnValue));
    }

Get more returns of a Stored Procedure (Linq to SQL)

1 Answers1