using System;

using Dotmim.Sync;

using Dotmim.Sync.SqlServer;

using Dotmim.Sync.Sqlite;

using Microsoft.Data.Sqlite;

using System.Threading.Tasks;

​

public class Program

{

    public static async Task Main()

    {

        // First step : Synchronize a Sqlite client database (that will be created on the fly)

        // Server database is the Northwind database

        await SynchronizeAsync();

        // Query the Sqlite client database, just to ensure rows are correctly synced

        await QueryClientDatabaseAsync();

    }

    private static async Task SynchronizeAsync()

    {

        // Create the Sql Sync Server provider

        var serverProvider = new SqlSyncProvider(FiddleHelper.GetConnectionStringSqlServerNorthwind());

        // Create a second provider  Sqlite.

        var clientProvider = new SqliteSyncProvider("northwind.db");

        // Tables to sync

        var setup = new SyncSetup("Customers", "Products", "Orders", "Order Details");

        // Creating an agent that will handle all the process

        var agent = new SyncAgent(clientProvider, serverProvider);

​

        // Using the Progress pattern to handle progession during the synchronization

        var progress = new SynchronousProgress<ProgressArgs>(s =>

            Console.WriteLine($"{s.ProgressPercentage:p}:  \t[{s?.Source[..Math.Min(4, s.Source.Length)]}] {s.TypeName}: {s.Message}"));

​

        // Launch the sync process

        var result = await agent.SynchronizeAsync(setup);

        // Write results

        Console.WriteLine(result);

    }

    private static async Task QueryClientDatabaseAsync()

    {

        Console.WriteLine("");

        Console.WriteLine("-------------------");

        using (var sqliteConnection = new SqliteConnection("Data Source=northwind.db"))

        {

            using (var sqlCommand = new SqliteCommand("Select * from Customers", sqliteConnection))

            {

                await sqliteConnection.OpenAsync();

                var reader = await sqlCommand.ExecuteReaderAsync();

                while (reader.Read())

                    Console.WriteLine($"{reader.GetString(2)}:\t{reader.GetString(3)}");

                sqliteConnection.Close();

            }

        }

    }

}