SharpCoreDB.Provider.Sync 2.1.0-RC.3

SharpCoreDB.Provider.Sync v2.1.0-RC.3

Dotmim.Sync Provider for SharpCoreDB

Bidirectional synchronization with SQL Server, PostgreSQL, MySQL, and SQLite - Phase 10.1 complete with enterprise conflict resolution.

Patch updates in v1.9.5 (archived; current release v2.1.0-RC.3)

• ✅ Parameterized query binding fixed (Issue #336): named-parameter binding is token-aware, so parameter names that are prefixes of others (e.g. @t vs @tid) no longer corrupt the SQL.
• ✅ Server parameter pass-through fixed (Issue #337): request.Parameters are forwarded on gRPC, the binary (PostgreSQL) protocol and WebSocket.
• ✅ ULID encoding is now standards-compliant: ULIDs follow the official Crockford Base32 spec and are interchangeable with Python/Java/Go implementations.
• ✅ NuGet dependencies updated to their latest stable versions.
• ✅ Aligned package metadata and version references to the synchronized 1.9.5 release line.
• ✅ Release automation now publishes all packable SharpCoreDB packages in CI/CD.

Features

• ✅ Phase 10.1 complete: Dotmim.Sync provider
• ✅ Bidirectional sync with SQL Server, PostgreSQL, MySQL, SQLite
• ✅ Shadow table change tracking
• ✅ Multi-tenant filtering for local-first AI agents
• ✅ Enterprise conflict resolution and compression

🚀 Key Features

• Bidirectional Sync: SharpCoreDB ↔ SQL Server/PostgreSQL/MySQL/SQLite
• Change Tracking: Shadow tables for incremental sync
• Multi-Tenant: Filter data by tenant for isolation
• Conflict Resolution: Automatic resolution with custom strategies
• Compression: 60-75% bandwidth reduction for large syncs
• Retry Logic: Enterprise-grade retry with exponential backoff

📊 Performance

• Initial Sync (1M rows): 45 seconds
• Incremental Sync (10K changes): <5 seconds
• Compression: 60-75% bandwidth reduction
• Throughput: 22K rows/sec (SQL Server → SharpCoreDB)

🎯 Use Cases

• Local-First AI Agents: Sync local SharpCoreDB with cloud SQL Server
• Offline-First Apps: Mobile/desktop with cloud sync
• Edge Computing: Edge devices syncing with central database
• Multi-Region: Regional databases syncing with central hub

💻 Quick Example

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

var localProvider = new SharpCoreDBSyncProvider(localConnectionString);
var remoteProvider = new SqlSyncProvider(sqlConnectionString);

var agent = new SyncAgent(localProvider, remoteProvider,
    new string[] { "Users", "Orders", "Products" });

var result = await agent.SynchronizeAsync();
Console.WriteLine($"Synced {result.TotalChangesDownloaded} changes from cloud");

📚 Documentation

• Sync Overview
• Sync Tutorial
• Conflict Resolution
• Full Documentation

📦 Installation

dotnet add package SharpCoreDB.Provider.Sync --version 2.1.0-RC.3

Requires: SharpCoreDB v1.9.5+, Dotmim.Sync.Core v1.3.0+

Version: 1.9.5 | Status: ✅ Production Ready | Phase: 10.1 Complete