SharpCoreDB.Extensions

Dapper Integration · Health Checks · Repository Pattern · Bulk Operations · Performance Monitoring · FluentMigrator

Version: 1.9.0
Status: Production Ready ✅

Convenience extensions package for SharpCoreDB.

• ✅ Aligned package metadata and version references to the synchronized 1.9.1 release line.
• ✅ Release automation now publishes all packable SharpCoreDB packages in CI/CD.

• Dapper integration helpers
• ASP.NET Core health check integration
• FluentMigrator integration hooks (optional)
• Repository/bulk utility helpers for common workflows
• Extension points for developer productivity in .NET applications

AddSharpCoreDBFluentMigrator() uses FluentMigrator's SQLite generator by default and now also defaults the processor to SQLite syntax compatibility.

This means SQLite-specific migration restrictions are enforced automatically for the standard registration path, which matches the generated SQL dialect and avoids unsupported DDL slipping through at runtime.

services.AddSharpCoreDB();
services.AddSingleton<DatabaseFactory>();
services.AddSingleton<IDatabase>();
services.AddSharpCoreDBFluentMigrator();

With the default registration:

• FluentMigrator generator id defaults to sqlite
• processor ProviderSwitches defaults to syntax=sqlite
• SQLite-incompatible operations such as ALTER COLUMN, CREATE SEQUENCE, and ALTER TABLE ... ADD CONSTRAINT are rejected with a clear NotSupportedException

If you need a different syntax mode, configure ProcessorOptions.ProviderSwitches explicitly after registration.

services.AddSharpCoreDBFluentMigrator();
services.Configure<ProcessorOptions>(options =>
{
    options.ProviderSwitches = "syntax=postgresql";
});

Explicit configuration is preserved and is not overwritten by the extension.

• Package/docs synchronized to v1.9.0
• Guidance updated for optional migration/health scenarios
• FluentMigrator now defaults to SQLite syntax compatibility when using AddSharpCoreDBFluentMigrator()
• Inherits core reliability improvements from SharpCoreDB v1.9.0

dotnet add package SharpCoreDB.Extensions --version 1.9.0

• docs/INDEX.md
• src/SharpCoreDB.Extensions/NuGet.README.md