public ConnectionSettingsCollection ToSqlServerConnectionSettings()
{
//optimistic initialization (IsValid = true)
ConnectionSettingsCollection list = new ConnectionSettingsCollection()
{
IsValid = true
};
foreach (DatabaseInstance i in this.DatabaseInstance)
{
foreach (Database db in i.Database)
{
SqlServerConnectionSettings cs = new SqlServerConnectionSettings()
{
Instance = i.Name,
Database = db.Name
};
cs.Validate();
if (!cs.IsValid)
{
list.IsValid = false;
}
list.Add(cs);
}
}
if (list.Count == 0)
{
list.IsValid = false;
}
return(list);
}
public ConnectionSettingsCollection ToOracleConnectionSettings()
{
//optimistic initialization (IsValid = true)
ConnectionSettingsCollection list = new ConnectionSettingsCollection()
{
IsValid = true
};
foreach (DatabaseInstance i in this.DatabaseInstance)
{
foreach (Database db in i.Database)
{
OracleConnectionSettings cs = new OracleConnectionSettings()
{
Instance = i.Name,
Database = db.Name,
//Schema = db.Schema.Name,
Port = i.PortNumber
};
foreach (string schema in db.Schema)
{
cs.Schema.Add(schema);
}
cs.Validate();
if (!cs.IsValid)
{
list.IsValid = false;
}
list.Add(cs);
}
}
if (list.Count == 0)
{
list.IsValid = false;
}
return(list);
}
public virtual bool PrepareAndValidateConnections()
{
ConnectionSettings = new ConnectionSettingsCollection();
switch (DatabaseType)
{
case DatabaseType.Oracle:
{
ConnectionSettings = this.DatabaseInstances.ToOracleConnectionSettings();
break;
}
case DatabaseType.SqlServer:
{
ConnectionSettings = this.DatabaseInstances.ToSqlServerConnectionSettings();
break;
}
}
IsValid &= ConnectionSettings.IsValid;
return(ConnectionSettings.IsValid);
}
