<p><a href="http://msdn.microsoft.com/en-us/data/jj691402.aspx">http://msdn.microsoft.com/en-us/data/jj691402.aspx</a></p>

      <p><a href="http://stackoverflow.com/questions/14343094/processing-multiple-result-sets-returned-from-a-stored-procedure-in-entity-frame">http://stackoverflow.com/questions/14343094/processing-multiple-result-sets-returned-from-a-stored-procedure-in-entity-frame</a></p>


      <script type="syntaxhighlighter" class="brush: sql"><![CDATA[
CREATE PROCEDURE dbo.TestItOut
	-- Add the parameters for the stored procedure here
	@PaymentGuid	UNIQUEIDENTIFIER,
	@CompanyGuid	UNIQUEIDENTIFIER
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT *
	FROM Payment p
	WHERE p.PaymentGuid = @PaymentGuid
	AND p.CompanyGuid = @CompanyGuid

	SELECT *
	FROM Performance pf
	WHERE pf.PaymentGuid = @PaymentGuid
	AND pf.CompanyGuid = @CompanyGuid

END
GO
]]></script>

      <script type="syntaxhighlighter" class="brush: csharp"><![CDATA[
 public Payment PaymentAndPerformances(Guid companyGuid, Guid paymentGuid)
        {
            using (var db = GetContext())
            {
                db.Database.Initialize(force: false);
                using (var cmd = db.Database.Connection.CreateCommand())
                {
                    cmd.CommandText = "[dbo].[TestItOut]";
                    cmd.CommandType = CommandType.StoredProcedure;

                    //add compnay guid param
                    var cParam = cmd.CreateParameter();
                    cParam.DbType = DbType.Guid;
                    cParam.ParameterName = "@CompanyGuid";
                    cParam.Value = companyGuid;
                    cParam.IsNullable = false;
                    cmd.Parameters.Add(cParam);

                    //add payment guid param
                    var pParam = cmd.CreateParameter();
                    pParam.DbType = DbType.Guid;
                    pParam.ParameterName = "@PaymentGuid";
                    pParam.Value = paymentGuid;
                    pParam.IsNullable = false;
                    cmd.Parameters.Add(pParam);

                    
                    db.Database.Connection.Open();
                    
                    using (var reader = cmd.ExecuteReader())
                    {
                        var payment = ((IObjectContextAdapter)db).ObjectContext.Translate<Payment>(reader: reader,
                            entitySetName: "Payments",
                            mergeOption: MergeOption.NoTracking).Single();

                        reader.NextResult();

                        var performances = ((IObjectContextAdapter)db).ObjectContext.Translate<Performance>(reader: reader,
                            entitySetName: "Performances",
                            mergeOption: MergeOption.NoTracking).ToList();

                        payment.Performances = performances;

                        return payment;
                    }
                }
            }
        }
]]></script>

Map multiple result sets with Entity Framework

Allan Chadwick

Map multiple SQL result sets with Entity Framework