Enum ChangeType
Defines the types of data changes captured by Change Data Capture (CDC) systems.
public enum ChangeType
- Extension Methods
Fields
Delete = 2An existing record was deleted.
For deletes, Before contains the deleted data (if available) and After is null.
Not all providers support delete detection or before-image capture for deletes. Check provider documentation for availability.
Insert = 0A new record was inserted.
For inserts, Before is null and After contains the inserted data.
Update = 1An existing record was updated.
For updates, Before contains the previous state (if available) and After contains the new state.
Not all providers support before-image capture. Check provider documentation for availability (e.g., MongoDB requires pre-image recording enabled).
Remarks
This enum provides a provider-agnostic representation of data change operations. All supported CDC providers map their native change types to these values:
| Provider | Native Mapping |
|---|---|
| SQL Server | Operation codes 1/2 (Delete), 3/4 (Insert), Update pairs |
| Postgres | Logical replication INSERT/UPDATE/DELETE messages |
| MongoDB | Change stream operationType: insert/update/replace/delete |
| CosmosDB | Change feed document changes (insert/update inferred, delete via TTL) |
| DynamoDB | Stream records: INSERT/MODIFY/REMOVE |