[TestClass]
  public class SyncFrameworkUnitTest
  {
    private string scopeName = "ContactsScope";

    /// <summary>
    /// Configure server scope
    /// </summary>
    [TestMethod]
    public void ProvisionServerScope()
    {
      using (SqlSyncProvider provider = new SqlSyncProvider())
      {
        provider.ScopeName = scopeName;

        //Create a new scope description and add the appropriate tables to this scope
        DbSyncScopeDescription scopeDescription = new DbSyncScopeDescription(this.scopeName);

        using (provider.Connection = new SqlConnection(@Properties.Settings.Default.ServerConnectionString))
        {
          // Provision the scope defined above
          SqlSyncScopeProvisioning sqlSyncScope = new SqlSyncScopeProvisioning((System.Data.SqlClient.SqlConnection)provider.Connection);

          // Does scope exist on the server and if not provision the scope
          if (!sqlSyncScope.ScopeExists(this.scopeName))
          {
            //Add the approrpiate tables to this scope
            scopeDescription.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable("[SalesLT].[Customer]", (System.Data.SqlClient.SqlConnection)provider.Connection));
            scopeDescription.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable("[SalesLT].[CustomerAddress]", (System.Data.SqlClient.SqlConnection)provider.Connection));
            scopeDescription.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable("[SalesLT].[Address]", (System.Data.SqlClient.SqlConnection)provider.Connection));

            // Note: Call this after the tables have been added to the scope
            sqlSyncScope.PopulateFromScopeDescription(scopeDescription);

            // Indicate that the base table already exists and does not need to be created
            sqlSyncScope.SetCreateTableDefault(DbSyncCreationOption.Skip);

            // Provision the server sync scope
            sqlSyncScope.Apply();
          }

          Assert.IsTrue(sqlSyncScope.ScopeExists(scopeName));
        }
      }
    }

    /// <summary>
    /// Configure client scope
    /// </summary>
    [TestMethod]
    public void ProvisionClientScope()
    {
      // Create a connection to the LocalDB database     
      using (SqlConnection clientConnection = new SqlConnection(@Properties.Settings.Default.LocalDBConnectionString))
      {

        // Create a connection to the Server database
        using (SqlConnection serverConnection = new SqlConnection(@Properties.Settings.Default.ServerConnectionString))
        {

          // Get the description of ProductsScope from the SyncDB server database
          DbSyncScopeDescription scopeDesc = SqlSyncDescriptionBuilder.GetDescriptionForScope(scopeName, serverConnection);

          // Create CE provisioning object based on the ProductsScope
          SqlSyncScopeProvisioning clientProvision = new SqlSyncScopeProvisioning(clientConnection, scopeDesc);

          if (!clientProvision.ScopeExists(scopeName))
          {
            clientProvision.Apply();
          }
        }
      }
    }


    [TestMethod]
    public void Synchronize()
    {
      SyncOperationStatistics syncStats = null;

      // Create a connection to the LocalDB database     
      using (SqlConnection clientConnection = new SqlConnection(@Properties.Settings.Default.LocalDBConnectionString))
      {
        // Create a connection to the Server database
        using (SqlConnection serverConnection = new SqlConnection(@Properties.Settings.Default.ServerConnectionString))
        {
          // Create the sync orhcestrator
          SyncOrchestrator syncOrchestrator = new SyncOrchestrator();

          // Set local provider of orchestrator to a LocalDB (SQL) provider associated with the 
          syncOrchestrator.LocalProvider = new SqlSyncProvider(scopeName, clientConnection);

          // Set the remote provider of orchestrator to a server sync provider associated with
          syncOrchestrator.RemoteProvider = new SqlSyncProvider(scopeName, serverConnection);

          // Set the direction of sync session to Upload and Download
          syncOrchestrator.Direction = SyncDirectionOrder.UploadAndDownload;

          // execute the synchronization process
          syncStats = syncOrchestrator.Synchronize();

          Assert.IsTrue(syncStats.SyncEndTime > syncStats.SyncStartTime);
        }
      }     
    }