How pets87/cdcsqlmonitor works
CDCSqlMonitor is a .NET library for polling SQL Server changes through either Change Tracking (CT) or Change Data Capture (CDC). A consumer configures and starts the chosen monitor, which polls SQL Server, builds change results, and dispatches data or error events back to the consumer. CT additionally supports table registration and in-code table setup; CDC returns column values and can expose raw captured rows. The monitor implementations were sampled; some event and model relationships are inferred from their declared types and documented API.
Main entry points: CT/Monitor.cs CT Monitor · CDC/Monitor.cs CDC Monitor · DataChangedEventArgs.cs CT Change Events · ErrorEventArgs.cs CT Error Events
Components 13
Change Tracking
- CT Monitor
CDCSqlMonitor/CT/Monitor.cs - Table Config
CDCSqlMonitor/CT/Models/MonitorTable.cs - CT Change Records
CDCSqlMonitor/CT/Models/Entity.cs - CT Change Events
CDCSqlMonitor/CT/EventArgs/DataChangedEventArgs.cs - CT Error Events
CDCSqlMonitor/CT/EventArgs/ErrorEventArgs.cs - SQL Server CT
Change Data Capture
- CDC Monitor
CDCSqlMonitor/CDC/Monitor.cs - CDC Raw Rows
CDCSqlMonitor/CDC/Models/CDCModel.cs - CDC Change Records
CDCSqlMonitor/CDC/Models/Entity.cs - CDC Change Events
CDCSqlMonitor/CDC/EventArgs/DataChangedEventArgs.cs - CDC Error Events
CDCSqlMonitor/CDC/EventArgs/ErrorEventArgs.cs - SQL Server CDC
Other components
- Library Consumer
Connections 19
- Library Consumer → CT Monitor: configures and starts
- CT Monitor → Table Config: stores table settings
- CT Monitor → SQL Server CT: enables CT tables
- CT Monitor → SQL Server CT: polls changes
- SQL Server CT → CT Monitor: returns key changes
- CT Monitor → CT Change Records: builds records
- CT Monitor → CT Change Events: dispatches changes
- CT Change Events → Library Consumer: delivers change batch
- CT Monitor → CT Error Events: dispatches errors
- CT Error Events → Library Consumer: delivers error
- Library Consumer → CDC Monitor: configures and starts
- CDC Monitor → SQL Server CDC: polls captured changes
- SQL Server CDC → CDC Monitor: returns captured rows
- CDC Monitor → CDC Raw Rows: maps raw rows
- CDC Monitor → CDC Change Records: builds change records
- CDC Monitor → CDC Change Events: dispatches changes
- CDC Change Events → Library Consumer: delivers change batch
- CDC Monitor → CDC Error Events: dispatches errors
- CDC Error Events → Library Consumer: delivers error