// @nuget: EntityFramework

// @nuget: Z.EntityFramework.Plus.EF6

// Website: https://entityframework-plus.net/

​

using System;

using System.Collections.Generic;

using System.Linq;

using System.Data.Entity;

using Z.EntityFramework.Plus;

​

public class Program

{   

    public static void Main()

    {

        // SEED

        using (var context = new EntityContext())

        {

            context.Customers.Add(new Customer() { Name = "Foo", });

            context.Customers.Add(new Customer() { Name = "Bar", });

            context.Customers.Add(new Customer() { Name = "Baz", });

            context.SaveChanges();

        }

        // TEST

        var queries = new List<object>()

        {

            new object(),

            new object(),

        };

        var listsOfCustomers = new CustomerService()

            .GetCustomersBulk(queries: queries);

        FiddleHelper.WriteTable("Customers 1", listsOfCustomers.First());

        FiddleHelper.WriteTable("Customers 2", listsOfCustomers.First());

    }

}

​

public class CustomerService

{

    private readonly EntityContext Context = new EntityContext();

    private IQueryable<Customer> MakeQuery(object query)

    {

        return this.Context.Customers

            // Omitted more logic here to create a complex query.

            .AsQueryable();

    }

​

    public List<List<Customer>> GetCustomersBulk(List<object> queries)

    {

        var response = new List<List<Customer>>();

        var futureQueries = new List<QueryFutureEnumerable<Customer>>();

​

        foreach (var query in queries)

        {

            futureQueries.Add(

                this.MakeQuery(query: query)

                    .Future()

            );

        }

        foreach (var futureQuery in futureQueries)

        {

            response.Add(futureQuery.ToList());

        }

​

        return response;

    }

}

​

public class EntityContext : DbContext

{

    public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())

    {

    }

    public DbSet<Customer> Customers { get; set; }

}

​

public class Customer

{

    public int id { get; set; }

    public string Name { get; set; }

}