public Model.Database GetSchema(string connectionString, Model.DatabaseTypes type)
{
Model.Database database = new Model.Database();
database.ConnString = connectionString;
database.Type = type;
//获取数据库结构
DBUtility.DbHelper dbHelper = DBUtility.DbHelper.Create("SqlServer");
dbHelper.ConnectionString = database.ConnString;
DataSet ds = dbHelper.ExecuteDataset(CommandType.Text,
GetSql(database.Type, SchemaHelper.SchemaType.Table), null);
List <Model.Table> tables = GetSQLTableList(ds);
foreach (Model.Table table in tables)
{
database.AddTable(table);
}
ds = dbHelper.ExecuteDataset(CommandType.Text,
GetSql(database.Type, SchemaHelper.SchemaType.View), null);
List <Model.Table> views = GetSQLTableList(ds);
foreach (Model.Table view in views)
{
database.AddView(view);
}
ds = dbHelper.ExecuteDataset(CommandType.Text, SqlForGetStoreProcedures, null);
database.StoreProcedures = GetSQLStoreProcedureList(ds);
return(database);
}
private void cobDatabase_DropDown(object sender, EventArgs e)
{
cobDatabase.Items.Clear();
DBUtility.DbHelper dbHelper = DBUtility.DbHelper.Create("Ase");
dbHelper.ConnectionString = string.Format(SqlConfig.GetAseConn,
txtServer.Text.Trim(),
txtPort.Text.Trim(),
txtUserName.Text.Trim(),
txtPassword.Text.Trim(),
"master");
try
{
DataSet ds = dbHelper.ExecuteDataset(CommandType.Text, "select name from sysdatabases where status2=1", null);
foreach (DataRow r in ds.Tables[0].Rows)
{
cobDatabase.Items.Add(r[0].ToString());
}
}
catch
{
}
}
public Model.Database GetSchema(string connectionString, Model.DatabaseTypes type)
{
Model.Database database = new Model.Database();
database.ConnString = connectionString;
database.Type = type;
//得到获取MySql结构的语句
string connStr = database.ConnString;
Match mDatabase = Regex.Match(connStr, @"Database=(?<Database>[^\;]*);");
if (mDatabase.Success)
{
database.Name = mDatabase.Groups["Database"].Value; //已赋数据库名
connStr = connStr.Replace(string.Format("Database={0};", database.Name), "Database=information_schema;");
}
else
{
return(null);
}
dbHelper = DBUtility.DbHelper.Create("MySql");
dbHelper.ConnectionString = connStr;
GetTables(database);
GetViews(database);
GetStoreProcedures(database);
return(database);
}
public Model.Database GetSchema(string connectionString, Model.DatabaseTypes type)
{
Model.Database db = new Model.Database();
db.ConnString = connectionString;
db.Type = type;
helper = DBUtility.DbHelper.Create("Oracle");
helper.ConnectionString = connectionString;
GetTables(db);
GetViews(db);
GetProcedures(db);
return(db);
}
private void cobDatabase_DropDown(object sender, EventArgs e)
{
cobDatabase.Items.Clear();
DBUtility.DbHelper dbHelper = DBUtility.DbHelper.Create("MySql");
dbHelper.ConnectionString = string.Format("Data Source={0};Port={1};User Id={2};Password={3};Database=information_schema;",
txtServer.Text.Trim(), txtPort.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim());
try
{
DataSet ds = dbHelper.ExecuteDataset(CommandType.Text, "select DISTINCT SCHEMA_NAME FROM SCHEMATA", null);
foreach (DataRow r in ds.Tables[0].Rows)
{
cobDatabase.Items.Add(r[0].ToString());
}
}
catch
{
}
}
private void cobDatabase_DropDown(object sender, EventArgs e)
{
cobDatabase.Items.Clear();
StringBuilder connStr = GetServer();
connStr.Append("Initial Catalog=master;");
DBUtility.DbHelper dbHelper = DBUtility.DbHelper.Create("SqlServer");
dbHelper.ConnectionString = connStr.ToString();
try
{
DataSet ds = dbHelper.ExecuteDataset(CommandType.StoredProcedure, "sp_databases", null);
foreach (DataRow r in ds.Tables[0].Rows)
{
cobDatabase.Items.Add(r["DATABASE_NAME"].ToString());
}
}
catch
{
}
}
