Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums how to read multiple result of procedure in EF 6 as async – MindStick
Ask Question

1 Answers

Utpal Vishwas
Utpal Vishwas 21 May 2025
Report Abuse

In Entity Framework 6 (EF6) on .NET Framework, reading multiple result sets from a stored procedure asynchronously is not directly supported out of the box. EF6 supports MultipleResults only via synchronous APIs. However, you can do it asynchronously by dropping down to DbContext.Database.SqlQuery and DbDataReader, using ExecuteReaderAsync.

Goal

Call a stored procedure that returns multiple result sets, e.g.:

CREATE PROCEDURE GetData
AS
BEGIN
    SELECT * FROM Products;
    SELECT * FROM Categories;
END

Solution: Use DbCommand + ExecuteReaderAsync

Here’s a full example using ADO.NET with EF6 DbContext to read multiple result sets asynchronously.

Step-by-Step Example

public async Task<(List<Product> Products, List<Category> Categories)> GetMultipleResultsAsync()
{
    using (var context = new YourDbContext())
    {
        var conn = context.Database.Connection;

        if (conn.State != ConnectionState.Open)
            await ((DbConnection)conn).OpenAsync();

        using (var command = conn.CreateCommand())
        {
            command.CommandText = "GetProductAndCategory";
            command.CommandType = CommandType.StoredProcedure;

            using (var reader = await ((DbCommand)command).ExecuteReaderAsync())
            {
                var products = ((IObjectContextAdapter)context)
                    .ObjectContext
                    .Translate<Product>(reader)
                    .ToList();

                await reader.NextResultAsync();

                var categories = ((IObjectContextAdapter)context)
                    .ObjectContext
                    .Translate<Category>(reader)
                    .ToList();

                return (products, categories);
            }
        }
    }
}

Calling the Method

In your controller or service:

public async Task<ActionResult> Index()
{
    var result = await GetMultipleResultsAsync();
    
    var products = result.Products;
    var categories = result.Categories;

    return View(new MyViewModel
    {
        Products = products,
        Categories = categories
    });
}

Explanation

Part Purpose
DbContext.Database.Connection Gets the underlying ADO.NET connection.
ExecuteReaderAsync() Executes the command and returns a DbDataReader.
Translate<T>() Maps raw data to your EF entity.
NextResultAsync() Advances to the next result set.

Notes

  1. Translate<T>() is only available in EF6 through ObjectContext.
  2. This pattern requires manual mapping, but it’s the only async-compatible way in EF6 to handle multiple result sets.
advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md