DKNet

Query and save through a repository

Part of DKNet.EfCore.Specifications. Use the Quick Start repository and modify its tracked write target:

var product = await db.Products.SingleAsync(p => p.Name == "Coffee");
product.Price = 15;
await repo.SaveChangesAsync();
Console.WriteLine(await repo.CountAsync(new MinimumPrice(10))); // 1

Operation	Use
Query<TEntity>(spec)	Deferred entity query; inspect SQL with ToQueryString().
AnyAsync, CountAsync	Existence or count after applying the specification.
FirstAsync, FirstOrDefaultAsync, ToListAsync	Materialize entities; First throws on an empty set, FirstOrDefault returns null.
AddAsync, AddRangeAsync	Stage inserts; save explicitly afterward.
Entry<TEntity>	Access the EF tracked entry.
UpdateAsync, UpdateRangeAsync	Mark entities modified and discover new navigation entities; save explicitly.
Delete	Stage a tracked deletion.
BulkDeleteAsync<TEntity>	ExecuteDeleteAsync immediately with a predicate.
BeginTransactionAsync	Begin a context database transaction; caller owns completion/disposal.
SaveChangesAsync	Add newly discovered navigation entities and invoke concurrency handling.

AddSpecRepo<TDbContext>() uses TryAddScoped for the repository and TryAddSingleton for IRepositorySpecFactory. The first repository registration wins, even if a later call names another context.

⚙️ Configuration reference

For background work, register an IDbContextFactory<DemoDb> (for example through AddDbContextFactory) before creating a provider:

var factory = provider.GetRequiredService<IRepositorySpecFactory>();
await using var owned = factory.CreateAsync<DemoDb>();
var count = await owned.Repository.CountAsync(new MinimumPrice(10));
Console.WriteLine(count);

Despite its name, CreateAsync<TDbContext>() returns IRepositorySpecProvider synchronously, not a Task. Disposing it disposes its context and DI scope.

🧱 Where it fits

The repository architecture shows query and persistence paths. Registered context interceptors still run during tracked saves. The save helper resolves a keyed IEfCoreExceptionHandler when available; this package does not install one.

⚠️ Gotchas & limits

• Keep the context/scope alive while materializing a deferred query or enumerating results.
• UpdateAsync does not commit; its integer result counts newly discovered navigation entities, not saved rows.
• BulkDeleteAsync bypasses SaveChanges and its audit/event/ownership hooks. It is not a per-entity Delete loop.
• The factory path requires IDbContextFactory registration; AddSpecRepo alone does not create that service.
• See the migration guide for the removed IRepository<T> surface; those packages no longer ship.

This site is open source. Improve this page.