/// <summary>
/// Test the connection
/// </summary>
/// <returns></returns>
private bool TestConnection()
{
string connectionString = GetConnectionString();
try
{
return(SqlDatabaseSchema.TestConnection(connectionString));
}
catch (Exception ex)
{
MessageBox.Show("Unable to connect.\n" + ex.Message);
}
return(false);
}
/// <summary>
/// Load schema in the database object
/// </summary>
private void LoadSchema()
{
_connectionString = GetConnectionString();
IDatabaseSchema dbSchema = new SqlDatabaseSchema();
_database = dbSchema.GetDataBaseSchema(txtSqlServer.Text, txtCatalog.Text, _connectionString);
// Set in global Valiable
TierGeneratorSettings.Instance.Database = _database;
TierGeneratorSettings.Instance.ConnectionString = _connectionString;
this.DialogResult = DialogResult.OK;
this.Close();
}
//public static DatabaseSchema CreateInstance()
//{
// return CreateInstance(GlobalService.DbType);
//}
public static DatabaseSchema CreateInstance(DatabaseType dbType)
{
if (dbType == DatabaseType.SqlServer)
{
SqlDatabaseSchema schema = new SqlDatabaseSchema();
schema.Provider = new SqlSchemaProvider();
return(schema);
}
if (dbType == DatabaseType.Access)
{
AccessDatabaseSchema schema = new AccessDatabaseSchema();
schema.Provider = new AccessSchemaProvider();
return(schema);
}
if (dbType == DatabaseType.Postgres)
{
var schema = new PostgresDatabaseSchema();
schema.Provider = new PostgresSchemaProvider();
return(schema);
}
return(null);
}
/// <summary>
/// Load schema in the database object
/// </summary>
private void LoadSchema()
{
_connectionString = GetConnectionString();
IDatabaseSchema dbSchema = new SqlDatabaseSchema();
_database = dbSchema.GetDataBaseSchema(txtSqlServer.Text, txtCatalog.Text, _connectionString);
//Load them DatabaseHist neu co
if (!string.IsNullOrEmpty(txtCatalog2.Text))
{
var connectHist = GetConnectionString2();
var databaseHist = dbSchema.GetDataBaseSchema(txtSqlServer.Text, txtCatalog2.Text, connectHist);
if (databaseHist != null)
{
foreach (var tableHist in databaseHist.Tables)
{
//Co truong hop lay giong bang nen check them
var table = _database.Tables.Find(s => s.TableName == tableHist.TableName);
if (table != null)
{
continue; //Da add
}
_database.Tables.Add(tableHist);
}
// _database.Tables.AddRange(databaseHist.Tables);
}
}
// Set in global Valiable
TierGeneratorSettings.Instance.Database = _database;
TierGeneratorSettings.Instance.ConnectionString = _connectionString;
this.DialogResult = DialogResult.OK;
this.Close();
}
