Project EF Core queries before materializing
Use Select to project only the required values before ToListAsync, reducing transferred columns and unnecessary entity materialization on EF Core read paths.
Ef-Core
Do not page without deterministic ordering
Give paged database queries a fully unique order so rows with the same sort value cannot move unpredictably between pages.
AsNoTracking belongs on read paths
Skip EF Core change tracking for queries that only read entity data, but keep tracking for load-change-save updates.
Generate Useful Test Data in .NET with Bogus
How to use the Bogus library to generate realistic, repeatable, and domain-shaped test data in .NET, including faker rules, related objects, seeds, and practical boundaries.
Prefer keyset pagination for deep lists
Use seek-based pagination when users move through large ordered result sets.
RAG with EF Core and pgvector
How to build RAG retrieval in .NET by storing embeddings in PostgreSQL with pgvector and querying them through EF Core.