Sometimes we have to perform several queries to the database, put the results into memory, and then process them as needed. For example, we have a Supplier table and a Customer table. Both tables have a substantial amount of data. We want to combine existing Supplier and Customer data with specific criteria. Generally, we will perform two queries sequentially: query to the Supplier table first, then query to the Customer table. The...

Entity Framework Core is recommended and the most popular tool for interacting with relational databases on ASP NET Core. It is powerful enough to cover most possible scenarios, but like any other tool, it has its limitations. Long time people said (not without reason) that Entity Frmaework does not match high load systems and for these scenarios it is better to use Dapper. But time goes by and Entity Framework...