Tips to improve EF Core performance include using projections, async methods, compiled queries, avoiding non-cancellable queries, using database context pool, using IQueryable for multiple filters, using AsNoTracking for read-only operations, and implementing pagination.

2m read timeFrom mwaseemzakir.substack.com
Post cover image
Table of contents
1/ Use projections2/ Use async methods3/ Use compiled queries4/ Avoid non-cancellable queries5/ Use database context pool6/ For multiple filters use IQueryable7/ Use AsNoTracking for read only operations8/ Use pagination, don't bring all data once

Sort: