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 |

Implement data access for the .NET 8 WPF widget host app using EF Core or Dapper. Use when creating repositories, unit of work, migrations, DbContext configuration, and query patterns while keeping clean architecture boundaries. Source: yosrbennagra/3sc.

View raw