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 |

使用 EF Core 或 Dapper 實現 .NET 8 WPF 小部件主機應用程序的數據訪問。在創建存儲庫、工作單元、遷移、DbContext 配置和查詢模式時使用，同時保持清晰的架構邊界。 來源：yosrbennagra/3sc。

查看原文