private static void ProcessConfigFile(ArgsParser parser)
{
DbSyncScopeDescription scopeDescription;
Dictionary <string, Dictionary <string, string> > tablesToColumnMappingsInfo = new Dictionary <string, Dictionary <string, string> >();
if (string.IsNullOrEmpty(parser.ConfigFile))
{
LogArgsError("Required argument /scopeconfig is not specified.");
return;
}
if (!System.IO.File.Exists(parser.ConfigFile))
{
LogArgsError("Unable to find scopeconfig file '" + parser.ConfigFile + "'");
return;
}
System.Configuration.Configuration config = ConfigurationManager.OpenMappedExeConfiguration(new ExeConfigurationFileMap()
{
ExeConfigFilename = parser.ConfigFile
}, ConfigurationUserLevel.None);
Log("Reading specified config file...");
SyncConfigurationSection syncConfig = config.GetSection(Constants.SyncConfigurationSectionName) as SyncConfigurationSection;
// ValidateConfigFile the config and the passed in input parameters
ValidateConfigFile(parser, syncConfig);
// Fill in the defaults value for the parser.
SelectedConfigSections selectedConfig = FillDefaults(parser, syncConfig);
Log("Generating DbSyncScopeDescription for scope {0}...", selectedConfig.SelectedSyncScope.Name);
scopeDescription = GetDbSyncScopeDescription(selectedConfig);
tablesToColumnMappingsInfo = BuildColumnMappingInfo(selectedConfig);
switch (parser.OperationMode)
{
case OperationMode.Provision:
Provision(selectedConfig, scopeDescription, false, parser.WorkingDirectory);
break;
case OperationMode.ProvisionScript:
Provision(selectedConfig, scopeDescription, true, parser.WorkingDirectory);
break;
case OperationMode.Deprovision:
Deprovision(selectedConfig, false, parser.WorkingDirectory);
break;
case OperationMode.DeprovisionScript:
Deprovision(selectedConfig, true, parser.WorkingDirectory);
break;
case OperationMode.Deprovisionstore:
DeprovisionStore(selectedConfig, false, parser.WorkingDirectory);
break;
case OperationMode.DeprovisionstoreScript:
DeprovisionStore(selectedConfig, true, parser.WorkingDirectory);
break;
case OperationMode.Codegen:
Log("Generating files...");
EntityGenerator generator = EntityGeneratorFactory.Create(parser.CodeGenMode, selectedConfig.SelectedSyncScope.SchemaName);
generator.GenerateEntities(parser.GeneratedFilePrefix,
string.IsNullOrEmpty(parser.Namespace)
? string.IsNullOrEmpty(parser.GeneratedFilePrefix) ? scopeDescription.ScopeName : parser.GeneratedFilePrefix
: parser.Namespace,
scopeDescription, tablesToColumnMappingsInfo, parser.WorkingDirectory, parser.Language, null /*serviceUri*/);
break;
default:
break;
}
}
private static void ProcessConfigFile(ArgsParser parser)
{
DbSyncScopeDescription scopeDescription;
var tablesToColumnMappingsInfo = new Dictionary <string, Dictionary <string, string> >();
if (string.IsNullOrEmpty(parser.ConfigFile))
{
LogArgsError("Required argument /scopeconfig is not specified.");
return;
}
if (!File.Exists(parser.ConfigFile))
{
LogArgsError("Unable to find scopeconfig file '" + parser.ConfigFile + "'");
return;
}
var config =
ConfigurationManager.OpenMappedExeConfiguration(
new ExeConfigurationFileMap {
ExeConfigFilename = parser.ConfigFile
}, ConfigurationUserLevel.None);
Log("Reading specified config file...");
var syncConfig = config.GetSection(Constants.SyncConfigurationSectionName) as SyncConfigurationSection;
// ValidateConfigFile the config and the passed in input parameters
ValidateConfigFile(parser, syncConfig);
// Fill in the defaults value for the parser.
var selectedConfig = FillDefaults(parser, syncConfig);
Log("Generating DbSyncScopeDescription for scope {0}...", selectedConfig.SelectedSyncScope.Name);
scopeDescription = GetDbSyncScopeDescription(selectedConfig);
tablesToColumnMappingsInfo = BuildColumnMappingInfo(selectedConfig);
switch (parser.OperationMode)
{
case OperationMode.Provision:
try
{
var prov =
new SqlSyncScopeProvisioning(
new SqlConnection(selectedConfig.SelectedTargetDatabase.GetConnectionString()),
scopeDescription,
selectedConfig.SelectedSyncScope.IsTemplateScope
? SqlSyncScopeProvisioningType.Template
: SqlSyncScopeProvisioningType.Scope);
// Note: Deprovisioning does not work because of a bug in the provider when you set the ObjectSchema property to “dbo”.
// The workaround is to not set the property (it internally assumes dbo in this case) so that things work on deprovisioning.
if (!String.IsNullOrEmpty(selectedConfig.SelectedSyncScope.SchemaName))
{
prov.ObjectSchema = selectedConfig.SelectedSyncScope.SchemaName;
}
foreach (SyncTableConfigElement tableElement in selectedConfig.SelectedSyncScope.SyncTables)
{
// Check and set the SchemaName for individual table if specified
if (!string.IsNullOrEmpty(tableElement.SchemaName))
{
prov.Tables[tableElement.GlobalName].ObjectSchema = tableElement.SchemaName;
}
prov.Tables[tableElement.GlobalName].FilterClause = tableElement.FilterClause;
foreach (FilterColumnConfigElement filterCol in tableElement.FilterColumns)
{
prov.Tables[tableElement.GlobalName].FilterColumns.Add(
scopeDescription.Tables[tableElement.GlobalName].Columns[filterCol.Name]);
}
foreach (FilterParameterConfigElement filterParam in tableElement.FilterParameters)
{
CheckFilterParamTypeAndSize(filterParam);
prov.Tables[tableElement.GlobalName].FilterParameters.Add(
new SqlParameter(filterParam.Name,
(SqlDbType)Enum.Parse(typeof(SqlDbType), filterParam.SqlType, true)));
prov.Tables[tableElement.GlobalName].FilterParameters[filterParam.Name].Size =
filterParam.DataSize;
}
}
// enable bulk procedures.
prov.SetUseBulkProceduresDefault(selectedConfig.SelectedSyncScope.EnableBulkApplyProcedures);
// Create a new set of enumeration stored procs per scope.
// Without this multiple scopes share the same stored procedure which is not desirable.
prov.SetCreateProceduresForAdditionalScopeDefault(DbSyncCreationOption.Create);
if (selectedConfig.SelectedSyncScope.IsTemplateScope)
{
if (!prov.TemplateExists(selectedConfig.SelectedSyncScope.Name))
{
Log("Provisioning Database {0} for template scope {1}...",
selectedConfig.SelectedTargetDatabase.Name, selectedConfig.SelectedSyncScope.Name);
prov.Apply();
}
else
{
throw new InvalidOperationException(
string.Format(
"Database {0} already contains a template scope {1}. Please deprovision the scope and retry.",
selectedConfig.SelectedTargetDatabase.Name,
selectedConfig.SelectedSyncScope.Name));
}
}
else
{
if (!prov.ScopeExists(selectedConfig.SelectedSyncScope.Name))
{
Log("Provisioning Database {0} for scope {1}...",
selectedConfig.SelectedTargetDatabase.Name, selectedConfig.SelectedSyncScope.Name);
prov.Apply();
}
else
{
throw new InvalidOperationException(
string.Format(
"Database {0} already contains a scope {1}. Please deprovision the scope and retry.",
selectedConfig.SelectedTargetDatabase.Name,
selectedConfig.SelectedSyncScope.Name));
}
}
}
catch (ConfigurationErrorsException)
{
throw;
}
catch (InvalidOperationException)
{
throw;
}
catch (Exception e)
{
throw new InvalidOperationException(
"Unexpected error when executing the Provisioning command. See inner exception for details.",
e);
}
break;
case OperationMode.Deprovision:
try
{
var deprov =
new SqlSyncScopeDeprovisioning(
new SqlConnection(selectedConfig.SelectedTargetDatabase.GetConnectionString()));
// Set the ObjectSchema property.
if (!String.IsNullOrEmpty(selectedConfig.SelectedSyncScope.SchemaName))
{
deprov.ObjectSchema = selectedConfig.SelectedSyncScope.SchemaName;
}
Log("Deprovisioning Database {0} for scope {1}...", selectedConfig.SelectedTargetDatabase.Name,
selectedConfig.SelectedSyncScope.Name);
if (selectedConfig.SelectedSyncScope.IsTemplateScope)
{
deprov.DeprovisionTemplate(selectedConfig.SelectedSyncScope.Name);
}
else
{
deprov.DeprovisionScope(selectedConfig.SelectedSyncScope.Name);
}
}
catch (Exception e)
{
throw new InvalidOperationException(
"Unexpected error when executing the Deprovisioning command. See inner exception for details.",
e);
}
break;
case OperationMode.Codegen:
Log("Generating files...");
var generator = EntityGeneratorFactory.Create(parser.CodeGenMode,
selectedConfig.SelectedSyncScope.SchemaName);
generator.GenerateEntities(parser.GeneratedFilePrefix,
string.IsNullOrEmpty(parser.Namespace)
? string.IsNullOrEmpty(parser.GeneratedFilePrefix)
? scopeDescription.ScopeName
: parser.GeneratedFilePrefix
: parser.Namespace,
scopeDescription, tablesToColumnMappingsInfo, parser.WorkingDirectory, parser.Language, null
/*serviceUri*/);
break;
default:
break;
}
}
