/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 vote237 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote231 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote151 views1 answer
How to set field to null in sql
SQL
5 votes167 views3 answers
How to remove unique key constraint in mysql
SQL
31 votes190 views4 answers
How to get duplicate records with multiple field in sql
SQL
6 votes226 views3 answers
Psql show columns of table
SQL
1 vote180 views1 answer
Count of tables in database mysql
SQL
0 vote141 views1 answer
Mysql find foreign key references
SQL
7 votes206 views2 answers
Phpmyadmin change password
SQL
1 vote174 views1 answer
Not exists mysql
SQL