What to use to improve EF Core performance?
Here are two EF Core methods I use to improve performance:
- AsNoTracking
- AsSplitQuery
AsNoTracking turns off change tracking, giving better performance.
AsSplitQuery splits a query with joins into multiple SQL queries, but use this cautiously.