Data Access Study Portal

TL;DR

EF Core 9 + Npgsql + EF Core migrations is the canonical .NET data stack. EF Core gives you LINQ queries, automatic change tracking, lazy loading (optional), and migration auto-generation from your entity model. Performance is excellent when used carefully; pitfalls (change-tracker bloat, lazy loading N+1, missing AsNoTracking) are real and well-documented. For genuine hot paths, drop to Dapper or raw NpgsqlCommand — and for bulk operations, use EFCore.BulkExtensions or Postgres COPY directly.