data-access

SKILL.md

Define reliable persistence patterns using EF Core while maintaining clean architecture boundaries between Infrastructure and Application layers.

| Singleton DbContext | Concurrency issues, stale data | Factory pattern, context per operation | | Missing AsNoTracking | Unnecessary memory, slower reads | Add AsNoTracking for read queries | | ToList() in Where clause | Loads all data to memory | Keep query as IQueryable | | N+1 queries | Multiple DB roundtrips | Use Include or projections |

| String interpolation in queries | SQL injection risk | Use parameterized queries |

Implementieren Sie den Datenzugriff für die .NET 8 WPF-Widget-Host-App mit EF Core oder Dapper. Zum Erstellen von Repositorys, Arbeitseinheiten, Migrationen, DbContext-Konfigurationen und Abfragemustern unter Beibehaltung sauberer Architekturgrenzen. Quelle: yosrbennagra/3sc.

Original anzeigen