Intercepting changes from client's local database

[ChristianFrom]

Hello, how do I intercept when something has changed in the client's local database?

[Mimetis]

Hi @ChristianFrom.

Depending on your need, you have two solutions:

If you want to know the rows to send, before trying to sync, you can use this kind of code:

// Creating an agent that will handle all the process
var agent = new SyncAgent(clientProvider, serverProvider, options, setup);

// Get changes to be populated to the server
var changes = await agent.LocalOrchestrator.GetChangesAsync();

// enumerate changes retrieved on the client, to be sent to server
foreach (var tableChanges in changes.ClientChangesSelected.TableChangesSelected)
{
    var enumerableOfTables = changes.ClientBatchInfo.GetTableAsync(
        tableChanges.TableName, tableChanges.SchemaName, options.SerializerFactory);
    
    var enumeratorOfTable = enumerableOfTables.GetAsyncEnumerator();

    while (await enumeratorOfTable.MoveNextAsync())
    {
        var table = enumeratorOfTable.Current;

        Console.WriteLine($"Changes for table {table.GetFullName()}");
        foreach (var row in table.Rows)
        {
            Console.WriteLine(row);
        }
    }
}

If you want to know what the rows really send to the server, during a sync, you can use an interceptor, like this:

// Creating an agent that will handle all the process
var agent = new SyncAgent(clientProvider, serverProvider, options, setup);

agent.LocalOrchestrator.OnTableChangesSelected(args =>
{
    if (args.Changes == null || args.Changes.Rows.Count == 0)
        return;

    foreach (var row in args.Changes.Rows)
        Console.WriteLine(row);
});

var s = await agent.SynchronizeAsync(progress);

[ChristianFrom]

Solution 2 worked perfectly for me, thanks for the help! I really appreciate it!