Table of Contents

Class SqlServerCdcIdempotencyFilterOptions

Namespace
Excalibur.Cdc.SqlServer
Assembly
Excalibur.Cdc.SqlServer.dll

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

string

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.