UseRowNumbers
Specifies whether the provider generates a RowNumber column to identify records when no custom schema is defined.
Data Type
bool
Default Value
false
Remarks
When this property is set to true, the connector creates a new column named RowNumber and uses it as the key for update and delete operations. When set to false, no row number column is created, and a custom schema must define a key column for modification operations.
This property is useful for performing update or delete operations on CSV files that do not include a natural primary key.