Class SqlServerCdcIdempotencyFilterOptions
Configuration options for the SQL Server CDC idempotency filter.
public sealed class SqlServerCdcIdempotencyFilterOptions
- Inheritance
-
SqlServerCdcIdempotencyFilterOptions
- Inherited Members
Remarks
Controls the schema, table name, retention period, and cleanup behavior for the persistent idempotency filter that tracks processed CDC events in a SQL Server table.
Properties
CleanupBatchSize
Gets or sets the maximum number of records to delete per cleanup batch. Prevents long-running DELETE transactions from blocking CDC processing.
public int CleanupBatchSize { get; set; }
Property Value
- int
The cleanup batch size. Defaults to 1000.
QualifiedTableName
Gets the fully qualified table name with bracket-escaping.
public string QualifiedTableName { get; }
Property Value
RetentionPeriod
Gets or sets the retention period for processed event records. Records older than this are eligible for cleanup.
public TimeSpan RetentionPeriod { get; set; }
Property Value
- TimeSpan
The retention period. Defaults to 24 hours.
SchemaName
Gets or sets the schema name for the processed events table.
[Required]
public string SchemaName { get; set; }
Property Value
- string
The schema name. Defaults to "Cdc".
TableName
Gets or sets the table name for tracking processed CDC events.
[Required]
public string TableName { get; set; }
Property Value
- string
The table name. Defaults to "CdcProcessedEvents".
Methods
Validate()
Validates the options and throws if invalid.
public void Validate()
Exceptions
- InvalidOperationException
Thrown when schema/table names are missing or contain invalid characters.