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。

查看原文