SharpCoreDB.Provider.Sync is the Dotmim.Sync provider for SharpCoreDB.

Version line: v1.9.0

• Sync provider documentation aligned to v1.9.0
• Clarified provider feature coverage for change tracking, metadata, and DI integration
• Linked package-level docs to centralized feature matrix and docs index

It enables bidirectional synchronization between SharpCoreDB and Dotmim.Sync-supported providers such as SQL Server, PostgreSQL, MySQL, and SQLite.

• Phase 4 (Testing & Integration): ✅ Complete
• Sync provider test suite: ✅ 84/84 passing
• Target: .NET 10, C# 14

• SharpCoreDBSyncProvider implements Dotmim.Sync CoreProvider
• Works as client and server provider (CanBeServerProvider = true)
• Connection via SharpCoreDB.Data.Provider (SharpCoreDBConnection)

SharpCoreDBSyncAdapter supports:

• SelectChanges
• SelectRow
• InsertRow
• UpdateRow
• DeleteRow
• SelectMetadata
• UpdateMetadata
• DeleteMetadata
• Batch execution (ExecuteBatchCommandAsync)

• Shadow tracking table per sync table: {table}_tracking
• Tracking columns:
  • primary key column (mirrored)
  • update_scope_id
  • timestamp
  • sync_row_is_tombstone
  • last_change_datetime
• Timestamp index for delta queries
• Trigger DDL generation for INSERT/UPDATE/DELETE
• Programmatic fallback for engines without trigger support via RecordChangeAsync

SharpCoreDBScopeInfoBuilder provisions and manages:

• scope_info
• scope_info_client

Includes full CRUD command generation for both tables plus SYNC_TIMESTAMP() support.

SharpCoreDBDbMetadata provides:

• DataType -> DbType
• DbType -> DataType
• DbType -> CLR Type
• DataType -> CLR Type
• DataType -> SQL type string
• Sync capability validation (DataType.Vector intentionally unsupported)

SyncServiceCollectionExtensions.AddSharpCoreDBSync() registers:

• SyncProviderOptions
• SyncProviderFactory
• SharpCoreDBSyncProvider
• SqliteDialect
• TrackingTableBuilder
• IChangeTrackingManager (ChangeTrackingManager)
• ITombstoneManager (TombstoneManager)

TombstoneManager supports:

• Cleanup with retention policy (CleanTombstonesAsync)
• Count retrieval (GetTombstoneCountAsync)

SyncProviderOptions:

• EnableAutoTracking (default true)
• TombstoneRetentionDays (default 30)
• BatchSize (default 500)
• AutoProvisionScopeTables (default true)
• CommandTimeoutSeconds (default 300)

using Dotmim.Sync;
using Dotmim.Sync.SqlServer;
using SharpCoreDB.Provider.Sync;

var local = new SharpCoreDBSyncProvider(
    "Path=C:\\data\\local.scdb;Password=secret",
    new SyncProviderOptions());

var remote = new SqlSyncProvider("Server=sql;Database=app;Trusted_Connection=True;");

var agent = new SyncAgent(local, remote);
var result = await agent.SynchronizeAsync(["Users", "Orders", "Products"]);

Console.WriteLine($"Uploaded: {result.TotalChangesUploaded}");
Console.WriteLine($"Downloaded: {result.TotalChangesDownloaded}");

Test project: tests/SharpCoreDB.Provider.Sync.Tests

• ProviderInitializationTests
• DependencyInjectionTests
• ChangeTrackingProvisioningTests
• PrimaryKeyDebugTests
• TypeMappingTests
• ScopeInfoBuilderTests

• SQLiteRoundtripTests
• EndToEndSyncScenarios
• SyncPerformanceBenchmarks
• SyncErrorHandlingTests

# Full provider test suite
dotnet test tests/SharpCoreDB.Provider.Sync.Tests/SharpCoreDB.Provider.Sync.Tests.csproj

# Integration only
dotnet test tests/SharpCoreDB.Provider.Sync.Tests/SharpCoreDB.Provider.Sync.Tests.csproj --filter "Integration"

Phase 4 delivered complete test infrastructure, scenario coverage, performance benchmarks, and error-path validation.

The sync provider is ready for full-system validation runs and release hardening.