public async Task LocalOrchestrator_MultipleScopes_ShouldHave_SameClientId()
        {
            var dbName = HelperDatabase.GetRandomName("tcp_lo_");
            await HelperDatabase.CreateDatabaseAsync(ProviderType.Sql, dbName, true);

            var cs          = HelperDatabase.GetConnectionString(ProviderType.Sql, dbName);
            var sqlProvider = new SqlSyncProvider(cs);

            var options = new SyncOptions();

            var localOrchestrator = new LocalOrchestrator(sqlProvider, options);

            var localScopeInfo1 = await localOrchestrator.GetClientScopeInfoAsync();

            var localScopeInfo2 = await localOrchestrator.GetClientScopeInfoAsync("A");

            var localScopeInfo3 = await localOrchestrator.GetClientScopeInfoAsync("B");

            Assert.Equal(localScopeInfo1.Id, localScopeInfo2.Id);
            Assert.Equal(localScopeInfo2.Id, localScopeInfo3.Id);


            // Check we get the 3 scopes
            var allScopes = await localOrchestrator.GetAllClientScopesInfoAsync();

            Assert.Equal(3, allScopes.Count);

            // Check the scope id, read from database, is good
            foreach (var scope in allScopes)
            {
                Assert.Equal(scope.Id, localScopeInfo1.Id);
            }


            HelperDatabase.DropDatabase(ProviderType.Sql, dbName);
        }