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 { } }