Ignore Inserts/Updates/Deletes feature

[JiriOgurek]

As an addendum to SyncDirection (Download/UploadOnly) I would suggest to add ignore Inserts/Updates/Deletes feature to cover all possible sync scenarios, such as mine ;-) What do you think about it?

[Mimetis]

Can you explain more what kind of scenario you have in mind ?

[JiriOgurek]

Sure, to be able ignore (to not synchronize) new inserted/updated/deleted records. It means to be able to do not track these (I/U/D) changes, or effeciantely delete them prior to sync.

[JiriOgurek]

It's been proposed to use OnTableChangesSelected event for deletes removal, in post above you have mentioned OnTableChangesSelectedSyncRow event, can you explain the difference of these two events, please?

[Mimetis]

OnTableChangesSelected is raised after all rows have been selected, and these rows are already seriliazed on disk and ready to be sent

OnTableChangesSelectedSyncRow is raised after during reading the data source. The row is still in memory and is not been, yet, serialized on the disk.

For your scenario, it's just a performance trick to avoid reading multiple times the row

[JiriOgurek]

So SyncRow event is prior to the other one, right?

[Mimetis]

yes, you can see it in the code here

Dotmim.Sync/Projects/Dotmim.Sync.Core/Orchestrators/BaseOrchestrator.GetChanges.cs

Line 158 in c69122b

internal virtual async Task<(TableChangesSelected TableChangesSelected, List<BatchPartInfo> BatchPartInfos)> ReadSyncTableChangesAsync(

[JiriOgurek]

Thank you for explanation, this leads me to initial idea to have boolean Inserts/Updates/Deletes Interest feature (default = true) to subscribe wanted changes, this would be very user-friendly feature.