I believe I have configured something wrong and getting trapped in following method of sync framework:
For any reason the framework is unable to find schema_info table and setting the IsProvisioned property to False.
protected override SyncSchemaInfo ReadSyncSchemaInfo(IDbConnection connection, IDbTransaction transaction, string objectPrefix, string objectSchema)
{
IDataReader reader = null;
IDbCommand command = null;
SyncSchemaInfo info;
bool flag = false;
bool flag2 = false;
try
{
flag = SyncUtil.OpenConnection(connection);
if (flag && (transaction != null))
{
throw new DbSyncException(SyncResource.GetString("OpenedConnectionWithNonNullTransaction"));
}
if (transaction == null)
{
transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
flag2 = true;
}
if (this.SelectSchemaInfoCommand == null)
{
SyncTracer.Error("Missing command '{0}' ", new object[] { "SelectSchemaInfoCommand" });
throw SyncExptEx.MissingProviderCommand("SelectSchemaInfoCommand", base.GetType().ToString(), "http://msdn.microsoft.com/sync");
}
string quotedTableName = ManagementUtils.GetQuotedPrefixedName(objectPrefix, ManagementUtils.SchemaInfoTableDefaultName, objectSchema);
string str2 = ManagementUtils.GetQuotedPrefixedName(objectPrefix, ManagementUtils.ScopeTableDefaultName, objectSchema);
if (!SqlManagementUtils.TableExists(connection, transaction, quotedTableName))
{
if (SqlManagementUtils.TableExists(connection, transaction, str2))
{
if (SqlManagementUtils.ColumnsForTable((SqlConnection) connection, (SqlTransaction) transaction, str2).Contains("[" + SqlSyncScopeTableHelper.ScopeNameColDefaultName
+ "]"))
{
SyncTracer.Error(SyncResource.GetString("SchemaInfoTableMissing"));
throw new DbProvisioningException(SyncResource.GetString("SchemaInfoTableMissing"));
}
return SqlSyncStoreMetadataUpgrade.V2_0Version;
}
SyncSchemaInfo currentVersion = SqlSyncStoreMetadataUpgrade.CurrentVersion;
currentVersion.IsProvisioned = false;
return currentVersion;
}
command = connection.CreateCommand();
command.CommandText = this.SelectSchemaInfoCommand.CommandText;
command.Transaction = transaction;
SyncTracer.Verbose("Reading Schema Version Info");
SyncTracer.TraceCommandAndParameters(command);
reader = command.ExecuteReader();
int ordinal = reader.GetOrdinal("schema_major_version");
int i = reader.GetOrdinal("schema_minor_version");
int num3 = reader.GetOrdinal("schema_extended_info");
if (!reader.Read())
{
throw new DbVersionException(SyncResource.FormatString("SchemaInfoNotFound", new object[] { ManagementUtils.GetQuotedPrefixedName(objectPrefix, ManagementUtils.SchemaInfoTableDefaultName,
objectSchema) }));
}
return new SyncSchemaInfo(reader.GetInt32(ordinal), reader.GetInt32(i), reader.GetString(num3));
}
finally
{
if (reader != null)
{
reader.Dispose();
}
if (command != null)
{
command.Dispose();
}
if (this.SelectSchemaInfoCommand != null)
{
this.SelectSchemaInfoCommand.Dispose();
}
if (flag2)
{
transaction.Commit();
transaction.Dispose();
}
if (flag)
{
connection.Close();
}
}
return info;
}
