RCommon.Dapper

Dapper implementation of the RCommon persistence abstractions. Provides a lightweight SQL mapper repository using Dapper and Dommel for CRUD operations with expression-based querying, while integrating with the RCommon data store factory and domain event tracking.

Features

• DapperRepository<TEntity> implementing ISqlMapperRepository<T>, IReadOnlyRepository<T>, and IWriteOnlyRepository<T>
• Expression-based querying via Dommel's SelectAsync, CountAsync, and AnyAsync extension methods
• CRUD operations mapped to SQL using Dommel's InsertAsync, UpdateAsync, and DeleteAsync
• Bulk delete support via DeleteMultipleAsync with expression predicates
• Find by primary key using Dommel's GetAsync
• Automatic connection lifecycle management (open/close per operation)
• Named data store support for multi-database scenarios through IDataStoreFactory and RDbConnection
• Fluent DI configuration to register database connections as named data stores
• Domain event tracking integrated into add, update, and delete operations
• Soft delete -- entities implementing ISoftDelete are automatically filtered on reads and logically deleted on writes
• Multitenancy -- entities implementing IMultiTenant are automatically filtered by tenant on reads and stamped with TenantId on writes
• Targets .NET 8, .NET 9, and .NET 10

Installation

dotnet add package RCommon.Dapper

Usage

// Configure in Program.cs or Startup builder.Services.AddRCommon() .WithPersistence<DapperPersistenceBuilder>(dapper => { dapper.AddDbConnection<ApplicationDbConnection>("ApplicationDb", options => { options.DbFactory = SqlClientFactory.Instance; options.ConnectionString = builder.Configuration.GetConnectionString("ApplicationDb"); }); dapper.SetDefaultDataStore(defaults => defaults.DefaultDataStoreName = "ApplicationDb"); });