/SQL/How to run parallel queries in sql server with entity framework

How to run parallel queries in sql server with entity framework

async Task<List<E1Entity>> GetE1Data()
{
    using(var MyCtx = new MyCtx())
    {
         return await MyCtx.E1.Where(bla bla bla).ToListAsync();
    }
}

async Task<List<E2Entity>> GetE2Data()
{
    using(var MyCtx = new MyCtx())
    {
         return await MyCtx.E2.Where(bla bla bla).ToListAsync();
    }
}

async Task DoSomething()
{
    var t1 = GetE1Data();
    var t2 = GetE2Data();
    await Task.WhenAll(t1,t2);
    DoSomething(t1.Result, t2.Result);
}

Source: stackoverflow.com

Similar codes

0 vote350 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote321 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote328 views1 answer
How should I pass a table name into a stored proc?
SQL
16 votes340 views3 answers
Jwt secret key generator laravel
SQL
0 vote346 views1 answer
Django how to get query result count
SQL
22 votes326 views4 answers
Show list of users in mysql
SQL
13 votes341 views6 answers
Mysql update from select
SQL
0 vote316 views0 answer
SQL
1 vote355 views1 answer
Postgresql escape single quote
SQL
3 votes358 views1 answer
Get current month last date in sql server
SQL