Forge.Repository

dotnet add package Forge.Repository
dotnet add package Forge.Repository.SqlServer   # or PostgreSql / Oracle / MySql

// 1. Register — Program.cs
builder.Services.AddForgeRepositorySqlServer<AppDbContext>(
    connectionString: builder.Configuration.GetConnectionString("ConnectionString")!,
    poolingOptions: new ForgeDbContextPoolingOptions { EnablePooling = true, MinPoolSize = 5, MaxPoolSize = 20 },
    configure: tuner => { tuner.SetRetry(3).SetTimeout(30).EnableLazyLoading(); });
 
// 2. Define your entity
public class Order : IAuditableBaseModel
{
    public string Id { get; set; } = Ulid.NewUlid().ToString();
    public string CustomerId { get; set; } = string.Empty;
    public decimal Total { get; set; }
    public DateTime CreatedOn  { get; set; }
    public DateTime ModifiedOn { get; set; }
    public string CreatedBy    { get; set; } = string.Empty;
    public string ModifiedBy   { get; set; } = string.Empty;
    public bool IsDeleted      { get; set; }
    public void OnCreate() => CreatedOn  = DateTime.UtcNow;
    public void OnUpdate() => ModifiedOn = DateTime.UtcNow;
    public void OnDelete() => IsDeleted  = true;
}
 
// 3. Use in a service
public class OrderService(IUnitOfWork uow)
{
    private readonly IRepositoryAsync<Order> _orders = uow.GetRepositoryAsync<Order>();
 
    public Task<IList<Order>> GetAllAsync(CancellationToken ct) => _orders.GetAllAsync(ct);
    public Task<Order> GetAsync(string id, CancellationToken ct) => _orders.GetByIdAsync(id, ct);
 
    public async Task PlaceAsync(Order order, CancellationToken ct)
    {
        await _orders.AddAsync(order, ct);
        await uow.SaveChangesAsync(ct);
    }
}