Resolving conflict help!

[Vextamour]

I have a WPF application that is always reading from the SQLite databases online or offline. Then anytime they navigate in the app or save anything I'm always making sync back calls through a WebAPI to keep the SQLite data up to date to the cloud Azure SQL Server. The issue I'm having is resolving conflicts in multiple scenarios below. Ultimately, I think I'm seeking help on how to resolve conflicts and chose what data to update or insert and sync back to the server. I've read documentation but I'm just not getting it to function properly. _At this point I'm not sure if it's allowed but I'd even be happy to pay for some 1:1 time because I need to get past this hold-up quickly. I've been scavenging through Issues and Discussions on here trying to find answers to no avail. I'm on DotMimSync version 0.9.4. Thank you kindly to anyone who can help me 🙏 !

One scenario is a basic ComputerA input data and ComputerB syncs up to the cloud. However, if I edit a row of data on ComputerB it raises a conflict on the client but never updates the cloud server. I've tried the two sync trick with no consistent luck (also I don't want to specify every single column by name) and attached my TWO SYNC code to say take the client edit over the server (code from local application below). If I step through the code I can see in LocalRow a value change. Then I see it update the RemoteRow value change but then it just never makes it to the server. Later down the road I would like to prompt the user asking which version of data they want but for now I need to get this just syncing at least.

Second scenario there are two computers running the application. ComputerA inserts or updates data then syncs up to the cloud while the person on ComputerB is still filling out an interface. Then ComputerB adds a row but it raises a conflict because the server says the row doesn't exist so it inserts into the SQLite database syncs up to the server and since it doesn't exist there it gets removed instantly out of local database.

                string clientDBConnectionString = Globals.SQLLiteConnectionString;
                string baseUrl = ConfigurationManager.AppSettings["BaseURL"];

                HttpClient httpClient = new HttpClient();
                httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", Globals.Auth0Token.Replace("Bearer ", ""));

                // Adding the HttpClient instance to the web client orchestrator
                var serverOrchestrator = new WebClientOrchestrator($"{baseUrl}api/sync", client: httpClient);

                //var serverOrchestrator = new WebClientOrchestrator("https://localhost:44368/api/sync"); //Uncomment this if you're trying to test the API sync locally
                var clientProvider = new SqliteSyncProvider(clientDBConnectionString);

                var options = new SyncOptions { ConflictResolutionPolicy = ConflictResolutionPolicy.ServerWins };
                
                var agent = new SyncAgent(clientProvider, serverOrchestrator, options);

                var localOrchestrator = agent.LocalOrchestrator;
                var remoteOrchestrator = agent.RemoteOrchestrator;

                try
                {

                    agent.LocalOrchestrator.OnApplyChangesFailed(acf =>
                    {
                        var localRow = acf.Conflict.LocalRow; //Local machine SQLite
                        var remoteRow = acf.Conflict.RemoteRow; //Azure SQL Server

                        //I don't want to have to call each row by name like this. I'd rather call it dynamically in a loop of sorts.
                        //Also in the future I'd like the user to pick but for now just trying to get the client to override what's going to the cloud server.
                        remoteRow["WellNumber"] = localRow["WellNumber"];

                        //I see the remote row updated the WellNumber based off the SQLite local row. 

                        //acf.FinalRow = localRow; /** TRIED FORCING THE FINAL ROW TO LOCAL ROW DIDN'T WORK EITHER**/
                        acf.SenderScopeId = null;
                    });

                    var results = await agent.SynchronizeAsync();

                        MessageBox.Show($"Sync duration: {results.CompleteTime.Subtract(results.StartTime).TotalSeconds}\n" +
                        $"Changes: {results.TotalChangesUploaded}\n" +
                        $"Downloaded: {results.TotalChangesDownloaded}\n" +
                        $"Applied: {results.TotalChangesApplied}\n" +
                        $"Conflicts: {results.TotalResolvedConflicts}");

                    results = await agent.SynchronizeAsync();

                    MessageBox.Show($"Sync duration: {results.CompleteTime.Subtract(results.StartTime).TotalSeconds}\n" +
                                    $"Changes: {results.TotalChangesUploaded}\n" +
                                    $"Downloaded: {results.TotalChangesDownloaded}\n" +
                                    $"Applied: {results.TotalChangesApplied}\n" +
                                    $"Conflicts: {results.TotalResolvedConflicts}");

[Vextamour]

@Mimetis I see you're active a lot on discussions and issues. Anyway possible you could take a look at this and provide feedback please? Or anyone else. My issue ticket has been open for 14 days and this one for 6 days and really need to progress on a project.

Just curious too I came across Microsoft.Datasync.Client NuGet package are you responsible for this too because it seems very familiar to what you're already doing.

[Mimetis]

Take my sample, modify the code to reproduce your issue, and share it

[Vextamour]

Thanks I'll replicate and report back. Started a new job so my side business development is getting backlogged sadly. Appreciate your help!

[Vextamour]

I got everything replicated, however, this is going from SQL Server DB to SQL Server DB. It worked testing between 3 separate databases I made on local as (separate clients). What tweaks do I need to make to have it go SQL Server (Main Server) to SQLite because that is where my issue is occurring.

[Mimetis]

hum, use a SqliteSyncProvider instead of a SqlSyncProvider ? (and adapt the queries using SqliteConnection to reproduce the user queries)

[Vextamour]

I'm still working on this. I started a new job and have made many modifications to my code base for this project. I'm almost to a point where I can focus on getting this functionality to test again. Thank you for the help!