Tips to get better performance for Entity Framework Core ★

Only get the row you need And the key reason for your slow query is it outputs too much data. Consider adding: Take(200) , Skip() to take only the data you need or the current page requires. Use a pager to generate the report. This might helps a lot. Consider the following code (...