title: EF Core: Multiple Where-queries simultaneously
body: <p>I'm trying to find the best practice in EF Core regarding reading data from multiple tables with minimal performance penalty incurred by round trips to the DB. Preferably I'd like a feature like pipeline in Redis where it's possible to queue the queries which causes them to be executed in just one round trip but I suppose that's not possible in SQL. I did expect it to be possible to send all queries asynchronous though so that they are executed simultaneously so I was surprised to find that DBContext does not support multiple concurrent queries. So given that, what is the best practice in EF Core to fetch data from multiple tables without waiting for multiple back-to-back round-trips to the DB-server?</p>