SyncData_dotNET 1.1.9

Example: class Program { private static readonly ClientSync Sync = ClientSync.GetClientSync();

    static void Main(string[] args)
    {
		// Tables involved in the sync process:
        var tables = new string[] { "anagrafica" };

        string server = "localhost";
        string database = "pwdmanager";
        string username = "root";
        string password = "toor";

		string clientConnectionString = Constants.FILEDB;
		string serverConnectionString = @"Data Source=" + server + "; Database=" + database + "; User ID=" + username + "; Password=" + password + ";";

        // Create 2 Sql Sync providers

        // Sqlite Client provider for a MySql <=> Sqlite sync
        SQLiteConnection clientProvider = new SQLiteConnection(clientConnectionString);

        // MySql Server provider, the master.
        MySqlConnection serverProvider = new MySqlConnection(serverConnectionString);

		// Launch the sync process
        var result = await Sync.Synchronize(clientProvider, serverProvider, tables);

        // Write results
		Console.WriteLine("Total changes downloaded: " + result.TotalChangesDownloaded);
		Console.WriteLine("Total changes uploaded: " + result.TotalChangesUploaded);
		Console.WriteLine("Total conflicts: " + result.TotalSyncConflicts);
		Console.WriteLine("Total errors: " + result.TotalSyncErrors);
		Console.WriteLine("Total StartTime: " + result.StartTime);
		Console.WriteLine("Total CompleteTime: " + result.CompleteTime);
		Console.WriteLine("Total duration: " + result.CompleteTime);
		Console.WriteLine("Total message: " + result.Message);
    }
}