/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 vote68 views1 answer
Import sql file in mysql linux
SQL
1 vote120 views1 answer
Create sqlite database in laravel
SQL
1 vote124 views2 answers
Create table if not exist
SQL
1 vote121 views1 answer
Sql select whole row max column
SQL
1 vote118 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote122 views1 answer
Replace multiple string in query sql
SQL
3 votes153 views1 answer
Oracle list invalid password logon denied
SQL
-1 vote125 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote126 views1 answer
Asp.net core sql server stored procedure
SQL
5 votes116 views3 answers
How to remove unique key constraint in mysql
SQL