// Sql Server provider, the master.
SqlSyncProvider serverProvider = new SqlSyncProvider(@"Data Source=(localdb)\MSSQLLocalDB; Initial Catalog=AdventureWorks;Integrated Security=true;");

// Sqlite Client provider for a Sql Server <=> Sqlite sync
SQLiteSyncProvider clientProvider = new SQLiteSyncProvider("advworks.db");

// Tables to be synced
var tables = new string[] {"ErrorLog", "ProductCategory",
    "ProductDescription", "ProductModel",
    "Product", "ProductModelProductDescription",
    "Address", "Customer", "CustomerAddress",
    "SalesOrderHeader", "SalesOrderDetail" };

// Agent
SyncAgent agent = new SyncAgent(clientProvider, serverProvider, tables);

do
{
    var s = await agent.SynchronizeAsync();
    Console.WriteLine($"Total Changes downloaded : {s.TotalChangesDownloaded}");

} while (Console.ReadKey().Key != ConsoleKey.Escape);

SqlSyncProvider serverProvider = new SqlSyncProvider(serverConfig);
SqlSyncProvider clientProvider = new SqlSyncProvider(clientConfig);

SyncConfiguration configuration = new SyncConfiguration(new string[] { "ServiceTickets" });

// With a config when we are in local mode (no proxy)
SyncConfiguration configuration = new SyncConfiguration(new string[] { "ServiceTickets" });

// Configure the default resolution priority
// Default : Server wins
configuration.ConflictResolutionPolicy = ConflictResolutionPolicy.ServerWins;
// Configure the batch size when memory is limited.
// Default : 0. Batch is disabled
configuration.DownloadBatchSizeInKB = 1000;
// Configure the batch directory if batch size is specified
// Default : Windows tmp folder
configuration.BatchDirectory = "D://tmp";
// configuration is stored in memory, you can disable this behavior
// Default : false
configuration.OverwriteConfiguration = true;
// Configure the default serialization mode (Json or Binary)
// Default : Json
configuration.SerializationFormat = SerializationFormat.Json;
// Configure the default model to Insert / Update / Delete rows (SQL Server use TVP to bulk insert)
// Default true if SQL Server
configuration.UseBulkOperations = true;


// Sync agent, running on client side
SyncAgent agent = new SyncAgent(clientProvider, serverProvider, configuration);

var session = await agent.SynchronizeAsync();

agent.SyncProgress += SyncProgress;

private static void SyncProgress(object sender, SyncProgressEventArgs e)
{
    switch (e.Context.SyncStage)
    {
        case SyncStage.BeginSession:
            Console.WriteLine($"Begin Session.");
            break;
        case SyncStage.EndSession:
            Console.WriteLine($"End Session.");
            break;
        case SyncStage.EnsureMetadata:
            if (e.Configuration != null)
                Console.WriteLine($"Configuration readed. {e.Configuration.ScopeSet.Tables.Count} table(s) involved.");
            if (e.DatabaseScript != null)
                Console.WriteLine($"Database is created");
            break;
        case SyncStage.SelectedChanges:
            Console.WriteLine($"Selected changes : {e.ChangesStatistics.TotalSelectedChanges}");
            break;
        case SyncStage.AppliedChanges:
            Console.WriteLine($"Applied changes : {e.ChangesStatistics.TotalAppliedChanges}");
            break;
        case SyncStage.WriteMetadata:
            if (e.Scopes != null)
                e.Scopes.ForEach(sc => Console.WriteLine($"\t{sc.Id} synced at {sc.LastSync}. "));
            break;
        case SyncStage.CleanupMetadata:
            Console.WriteLine($"CleanupMetadata");
            break;
    }
}

    public void ConfigureServices(IServiceCollection services)
    {
        services.AddMvc();

        var connectionString = Configuration["Data:ConnectionString"];
        services.AddSyncServer<SqlSyncProvider>(connectionString, configuration =>
        {
            configuration.Tables = new string[] { "ServiceTickets" };
        });
    }

[Route("api/[controller]")]
public class ValuesController : Controller
{
    // GET api/values
    [HttpGet]
    public IEnumerable<string> Get()
    {
        return new string[] { "value1", "value2" };
    }
  
    // proxy to handle requests and send them to SqlSyncProvider
    private WebProxyServerProvider webProxyServer;

    // Injected thanks to Dependency Injection
    public ValuesController(WebProxyServerProvider proxy)
    {
        webProxyServer = proxy;
    }

    // Handle all requests :)
    [HttpPost]
    public async Task Post()
    {
        await webProxyServer.HandleRequestAsync(this.HttpContext);
    }
}

    var clientProvider = new SqlSyncProvider("[ConnectionString]");
    var proxyClientProvider = new WebProxyClientProvider(new Uri("http://localhost:56782/api/values"));

    var agent = new SyncAgent(clientProvider, proxyClientProvider);

    Console.WriteLine("Press a key to start...(Wait for you Web API is ready) ");
    Console.ReadKey();

    Console.Clear();
    Console.WriteLine("Sync Start");
        var s = await agent.SynchronizeAsync();