private IList <SearchHit> GetViewSearchResults(Sql8rServer s, Sql8rDatabase db, string criteria, bool exactMatch, bool caseSensitive, bool includeSystemObjects) { var hits = new List <SearchHit>(); if (db != null) { foreach (Sql8rView v in db.Views) { if (!v.IsSystemObject || (v.IsSystemObject && includeSystemObjects)) { IList <SearchHit> hit = checkForHit(s, db, v.IsSystemObject, SearchAreas.View, v, criteria, exactMatch, caseSensitive); hits.AddRange(hit); } } } else { foreach (Sql8rDatabase d in s.Databases) { foreach (Sql8rView v in d.Views) { if (!v.IsSystemObject || (v.IsSystemObject && includeSystemObjects)) { IList <SearchHit> hit = checkForHit(s, db, v.IsSystemObject, SearchAreas.View, v, criteria, exactMatch, caseSensitive); hits.AddRange(hit); } } } } return(hits); }
public Query GetAlterColumnQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, Sql8rColumn column) { string sql = string.Format(sqlAlterColumn, database.Name, table.GetFullObjectName(), column.Name); var query = new Query(_settings, server.Name, database.Name, sql); return(query); }
public Sql8rServer GetServer() { var s = new Sql8rServer(_settings); string dbConn = ConnectionString; setServerInfo(ref s, dbConn); OdbcConnection cn = new OdbcConnection(dbConn); cn.Open(); // DataTable schema = cn.GetSchema(); // collectionName, nbrOfRestriction, nbrOfIden // foreach (DataRow row in schema.Rows) // { // string collection = row["CollectionName"].ToString(); // "MetaDataCollections" "DataSourceInformation" // "DataTypes" "Restrictions" "ReservedWords" // "Columns" "Indexes" "Procedures" "ProcedureColumns" // "ProcedureParameters" "Tables" // } Sql8rDatabase db = new Sql8rDatabase("main", 0); s.Databases.Add(db); DataTable dtColumns = cn.GetSchema("Columns"); DataTable dtTables = cn.GetSchema("Tables"); // collectionName, nbrOfRestriction, nbrOfIden foreach (DataRow row in dtTables.Rows) { string tCategory = row["TABLE_CAT"].ToString(); string tSchema = row["TABLE_SCHEM"].ToString(); string tName = row["TABLE_NAME"].ToString(); bool tIsSystem = row["TABLE_TYPE"].ToString().ToString().Equals("SYSTEM TABLE", StringComparison.InvariantCultureIgnoreCase) ? true : false; string tRemarks = row["REMARKS"].ToString(); Sql8rTable t = new Sql8rTable(tName, tSchema, tIsSystem, 0); int id = 0; foreach (DataRow column in dtColumns.Select(string.Format("TABLE_NAME = '{0}'", t.Name))) { string taSchema = column["TABLE_SCHEM"].ToString(); string taName = column["TABLE_NAME"].ToString(); string cName = column["COLUMN_NAME"].ToString(); string cDataType = column["DATA_TYPE"].ToString(); string cTypeName = column["TYPE_NAME"].ToString(); int cSize = int.Parse(column["COLUMN_SIZE"].ToString()); Sql8rColumn c = new Sql8rColumn(cName, false, cTypeName, cSize, id++); t.Columns.Add(c.ObjectId, c); } db.Tables.Add(t); } return(s); }
public Query GetTableContent(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, bool editable) { string sql = "SELECT * FROM {0};"; string dbSQL = string.Format(sql, table.Name); string dbConn = ConnectionString; using (var conn = new SQLiteConnection(dbConn)) { conn.Open(); var cmd = new SQLiteCommand(dbSQL, conn); var sdaDatabases = new SQLiteDataAdapter(cmd); if (editable) { var scb = new SQLiteCommandBuilder(sdaDatabases); sdaDatabases.UpdateCommand = scb.GetUpdateCommand(); sdaDatabases.InsertCommand = scb.GetInsertCommand(); sdaDatabases.DeleteCommand = scb.GetDeleteCommand(); } var dsDatabases = new DataTable("TableContent"); sdaDatabases.Fill(dsDatabases); var query = new Query(_settings, server.Name, database.Name, dbSQL, dsDatabases); query.Adapter = sdaDatabases; return(query); } }
public Query GetTableContent(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, bool editable) { string sql = ResourceReader.GetResourceSql("SQL8r.Logic.SqlServer.Queries.UI.OpenTable.sql"); string dbSQL = string.Format(sql, database.Name, table.Schema, table.Name); var conn = new SqlConnection(ConnectionString); conn.Open(); conn.ChangeDatabase(database.Name); var cmd = new SqlCommand(dbSQL, conn); var sdaDatabases = new SqlDataAdapter(cmd); if (editable) { var scb = new SqlCommandBuilder(sdaDatabases); sdaDatabases.UpdateCommand = scb.GetUpdateCommand(); sdaDatabases.InsertCommand = scb.GetInsertCommand(); sdaDatabases.DeleteCommand = scb.GetDeleteCommand(); } var dsDatabases = new DataTable("TableContent"); sdaDatabases.Fill(dsDatabases); var query = new Query(_settings, server.Name, database.Name, dbSQL, dsDatabases); query.Adapter = sdaDatabases; return(query); }
public Query GetAlterColumnQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, Sql8rColumn column) { // throw new System.NotImplementedException(); string sql = string.Format(sqlAlterColumn, table.GetFullObjectName(), column.Name); var query = new Query(_settings, server.Name, database.Name, sql); return(query); }
public void ShowUsage(Sql8rServer s, Sql8rDatabase db, Sql8rTable t, string fileName) { _s = s; _db = db; _t = t; bindData(t); _view.Text = string.Format("{0}: {1}", MainPresenter.MdiTabKeys.TableUsage, fileName); }
public Sql8rServer GetServer() { // string sqlDatabases = "SELECT type, name, tbl_name, rootpage, sql FROM main.SQLITE_MASTER;"; var s = new Sql8rServer(_settings); string dbConn = ConnectionString; setServerInfo(ref s, dbConn); var sdaTables = new SQLiteDataAdapter(sqlDatabases, dbConn); var dtTables = new DataTable("TablesEtc"); sdaTables.Fill(dtTables); string dbName = _settings.DatabaseName; if (File.Exists(_settings.DatabaseName)) { dbName = Path.GetFileName(_settings.DatabaseName); } var db = new Sql8rDatabase(dbName, 0); s.Databases.Add(db); var systable = new Sql8rTable("SQLITE_MASTER", "main", true, 0); addColumns(systable); db.Tables.Add(systable); foreach (DataRow drTable in dtTables.Select("type = 'table'")) { string t_name = drTable.Field <string>("name"); long t_rootpage = drTable.Field <long>("rootpage"); // string sql = drTable.Field<string>("sql"); var table = new Sql8rTable(t_name, "", false, t_rootpage); addColumns(table); foreach (DataRow drIndex in dtTables.Select("type = 'index' AND tbl_name = '" + t_name + "'")) { string i_name = drIndex.Field <string>("name"); long i_rootpage = drIndex.Field <long>("rootpage"); var index = new Sql8rIndex(i_name, false, false, i_rootpage); table.Indexes.Add(index.Name, index); } db.Tables.Add(table); //if (type.Equals("trigger", StringComparison.InvariantCultureIgnoreCase)) //{ // var trigger = new Sql8rTrigger(name, "", false); //} } return(s); }
public new Query GetReorganizeIndexQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, Sql8rIndex index) { string sql = ResourceReader.GetResourceSql("SQL8r.Logic.SqlServer.Queries.UI.ReorganizeIndex.sql"); string head = string.Format(sql, database.Name, index.Name, table.Schema, table.Name, index.ObjectId); var query = new Query(Settings, server.Name, database.Name, head); return(query); }
public Query GetExecuteProcedureQuery(Sql8rServer server, Sql8rDatabase database, Sql8rProcedure procedure) { var myConnection = new MySqlConnection(); myConnection.ConnectionString = String.Format( "{0};database={1}", ConnectionString, database.Name); MySqlDataReader myReader = null; string paramsString = string.Empty; try { myConnection.Open(); var myCommand = new MySqlCommand(); myCommand.CommandText = string.Format( "SHOW CREATE PROCEDURE `{0}`", procedure.Name); myCommand.CommandType = CommandType.Text; myCommand.Connection = myConnection; myReader = myCommand.ExecuteReader(); if (myReader.Read()) { paramsString = myReader.GetString(2); } } finally { myReader.Close(); myConnection.Close(); } string head = string.Format("EXEC {0}", procedure.Name); var reg = new Regex(@"(?<=\x28)([^\n\r]+)(?=\x29)"); Match match = reg.Match(paramsString); paramsString = match.Groups[1].Value; char[] paramsSplitter = { ',' }; string[] paramsSet = paramsString.Split(paramsSplitter); foreach (string param in paramsSet) { char[] paramPartSplitter = { ' ' }; string[] paramPart = param.TrimStart().Split(paramPartSplitter); head = string.Format("{0} {1} {2}=<{3}>", head, paramPart[0], paramPart[1], paramPart[2]); } var q = new Query(_settings, server.Name, database.Name, head); return(q); }
public Query GetExecuteFunctionQuery(Sql8rServer server, Sql8rDatabase database, Sql8rFunction function) { string head = string.Format("EXEC {0}.{1}", function.Schema, function.Name); string use = string.Format("USE {0} ", database.Name); string vars = ""; string dbSQL = string.Format(sqlParameters, database.Name, function.ObjectId); var sdaParameters = new SqlDataAdapter(dbSQL, ConnectionString); var dtParameters = new DataTable("Parameters") { Locale = CultureInfo.InvariantCulture }; sdaParameters.Fill(dtParameters); string sep = ","; int count = dtParameters.Rows.Count; for (int i = 0; i < count; i++) { DataRow drDatabase = dtParameters.Rows[i]; int paramId = int.Parse(drDatabase["parameterId"].ToString()); string paramName = drDatabase["pName"].ToString(); bool isOutput = bool.Parse(drDatabase["isOutput"].ToString()); string typeName = drDatabase["tName"].ToString(); if (i == count - 1) { sep = ""; } if (!isOutput) { head = string.Format("{0} {1}=<{2}>{3}", head, paramName, typeName, sep); } else if (paramId > 0) { vars = string.Format("DECLARE {0} {1};{2}", paramName, typeName, Environment.NewLine); head = string.Format("{0} {1} OUTPUT{2}", head, paramName, sep); } else { vars = string.Format("DECLARE @result {0};{1}", typeName, Environment.NewLine); } } string sql = string.Format("{0}{1}{2}{3}{4}", use, Environment.NewLine, vars, Environment.NewLine, head); var query = new Query(_settings, server.Name, database.Name, sql); return(query); }
public Sql8rServer GetServer() { var s = new Sql8rServer(_settings); Sql8rDatabase db = new Sql8rDatabase("MYDB.FDB", 0); Sql8rTable t = new Sql8rTable("table1", "", false, 0); db.Tables.Add(t); s.Databases.Add(db); return(s); }
public Query GetTableQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table) { var s = new Server(server.Name); Database db = s.Databases[database.Name]; Table v = db.Tables[table.Name, table.Schema]; StringCollection tableSqls = v.Script(); string viewSql = string.Format("{0}{1}{2}{3}{4}{5}", tableSqls[0], Environment.NewLine, tableSqls[1], Environment.NewLine, Environment.NewLine, tableSqls[2]); var query = new Query(_settings, server.Name, database.Name, viewSql); return(query); }
// private ServerConnectionSettings _settings; #region IPerformanceManager Members //public ServerVersionId ManagerName //{ // get { return ServerVersionId.SqlServer_2008; } //} // public ServerConnectionSettings Settings // { // set { _settings = value; } //} public new Query GetRebuildIndexQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, Sql8rIndex index) { string sql = ResourceReader.GetResourceSql("SQL8r.Logic.SqlServer.Queries.UI.RebuildIndex.sql"); string head = string.Format(sql, database.Name, index.Name, table.Schema, table.Name); if (server.Edition == ServerEditions.EnterpriseEdition) { head += " WITH ONLINE = ON"; } var query = new Query(Settings, server.Name, database.Name, head); return(query); }
public Query GetViewContent(Sql8rServer server, Sql8rDatabase database, Sql8rView view) { string sql = ResourceReader.GetResourceSql("SQL8r.Logic.SqlServer.Queries.UI.OpenView.sql"); string dbSQL = string.Format(sql, database.Name, view.Schema, view.Name); var sdaDatabases = new SqlDataAdapter(dbSQL, ConnectionString); var dsDatabases = new DataTable("ViewContent"); sdaDatabases.Fill(dsDatabases); var query = new Query(_settings, server.Name, database.Name, dbSQL, dsDatabases); return(query); }
//public MySqlDatabaseHandler() //{ //} //public MySqlDatabaseHandler(ServerConnectionSettings si) //{ // _settings = si; //} #region IDatabaseManager Members public Query GetTableContent(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, bool editable) { string sql = ResourceReader.GetResourceSql("SQL8r.Logic.MySQL.Queries.UI.OpenTable.sql"); string dbConn = ConnectionString; string dbSQL = string.Format(sql, database.Name, table.Name); var mdaDatabases = new MySqlDataAdapter(dbSQL, dbConn); var dsDatabases = new DataTable("TableContent"); mdaDatabases.Fill(dsDatabases); var q = new Query(_settings, server.Name, database.Name, dbSQL, dsDatabases); return(q); }
public Query GetTableContent(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, bool editable) { string dbConn = ConnectionString; string dbSQL = string.Format("SELECT * FROM [{0}]", table.Name); var sdaDatabases = new OdbcDataAdapter(dbSQL, dbConn); var dsDatabases = new DataTable("TableContent"); sdaDatabases.Fill(dsDatabases); var query = new Query(_settings, server.Name, database.Name, dbSQL, dsDatabases); return(query); //return dsDatabases; }
public Query GetViewQuery(Sql8rServer server, Sql8rDatabase database, Sql8rView view) { string sql = ResourceReader.GetResourceSql("SQL8r.Logic.SqlServer.Queries.UI.EditView.sql"); string dbSQL = string.Format(sql, database.Name, view.ObjectId); var dtTables = new DataTable("ViewQuery"); var sdaTables = new SqlDataAdapter(dbSQL, ConnectionString); sdaTables.Fill(dtTables); DataRow drDatabase = dtTables.Rows[0]; string def = drDatabase["definition"].ToString(); var query = new Query(_settings, server.Name, database.Name, def); return(query); }
private void search() { string searchArea = _view.cboSearchAreaType.Text; string searchCriteria = _view.txtSearchArea.Text; bool caseSensitive = _view.chkCaseSensitive.Checked; bool exactMatch = _view.chkExactMatch.Checked; bool includeSystemObjects = _view.chkIncludeSystemObjects.Checked; ServerNode sn = MainPresenter.Instance.GetServerNode(); DatabaseNode dbn = MainPresenter.Instance.GetDatabaseNode(); if (sn != null) { Sql8rServer s = sn.ServerObject; Sql8rDatabase db = null; if (dbn != null) { db = dbn.DatabaseObject; } var factory = SearchManagerFactory.Instance; ISearchManager man = factory.GetDomainSearchManager(); _view.grdResults.DataSource = null; if (searchArea == SearchAreas.Table) { _view.grdResults.DataSource = man.SearchAllTables(s, db, searchCriteria, exactMatch, caseSensitive, includeSystemObjects); } else if (searchArea == SearchAreas.View) { _view.grdResults.DataSource = man.SearchAllViews(s, db, searchCriteria, exactMatch, caseSensitive, includeSystemObjects); } if (_view.grdResults.DisplayLayout.Bands.Count > 0) { autoSizeAllColumns(_view.grdResults.DisplayLayout.Bands[0]); } } else { MainPresenter.Instance.SetError("No active connection"); } }
public Query GetTableQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table) { string sql = ResourceReader.GetResourceSql("SQL8r.Logic.MySQL.Queries.UI.EditTable.sql"); string dbConn = ConnectionString; string dbSQL = string.Format(sql, database.Name, table.Name); var dtTables = new DataTable("ViewTable"); var mdaTables = new MySqlDataAdapter(dbSQL, dbConn); mdaTables.Fill(dtTables); DataRow drDatabase = dtTables.Rows[0]; string def = drDatabase["Create Table"].ToString(); var q = new Query(_settings, server.Name, database.Name, def); return(q); }
public Query GetTableContent(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, bool editable) { // const string inventoryDbName = @"C:\Users\niklas\Desktop\inventory.db"; // const string inventoryDbName = @"C:\Users\niklas\Desktop\mydb.fdb"; // string connectionString = "ServerType=1;User=SYSDBA;Password=masterkey;Dialect=3;Database="; // FbDataAdapter da = new FbDataAdapter("SELECT * FROM table1", connectionString + this.textBox1.Text); string sql = "SELECT * FROM {0};"; string dbSQL = string.Format(sql, "table1"); string dbConn = ConnectionString; dbConn = @"ServerType=1;User=SYSDBA;Password=masterkey;Dialect=3;Database=MYDB.FDB"; FbConnection conn = new FbConnection(dbConn); conn.Open(); // conn.ChangeDatabase(database.Name); var cmd = new FbCommand(dbSQL, conn); var sdaDatabases = new FbDataAdapter(cmd); if (editable) { var scb = new FbCommandBuilder(sdaDatabases); sdaDatabases.UpdateCommand = scb.GetUpdateCommand(); sdaDatabases.InsertCommand = scb.GetInsertCommand(); sdaDatabases.DeleteCommand = scb.GetDeleteCommand(); } var dsDatabases = new DataTable("TableContent"); sdaDatabases.Fill(dsDatabases); var query = new Query(_settings, server.Name, database.Name, dbSQL, dsDatabases); query.Adapter = sdaDatabases; return(query); }
//public Query GetAddIndexQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table) //{ // string sql = string.Format(sqlAddIndex, database.Name, table.GetFullObjectName()); // var query = new Query(_settings, server.Name, database.Name, sql); // return query; //} public Sql8rServer GetServer() { const bool parallellize1 = true; log.Debug("Enter GetServer"); var s = new Sql8rServer(_settings); setServerInfo(ref s, ConnectionString); var sdaDatabases = new SqlDataAdapter(sqlDatabases, ConnectionString); var dtDatabases = new DataTable("Databases"); sdaDatabases.Fill(dtDatabases); log.Debug("Got Databases"); if (parallellize1) { var arDatabases = new DataRow[dtDatabases.Rows.Count]; dtDatabases.Rows.CopyTo(arDatabases, 0); Parallel.ForEach(arDatabases, drDatabase => { Sql8rDatabase db = createDb(ConnectionString, drDatabase); s.Databases.Add(db); }); } else { foreach (DataRow drDatabase in dtDatabases.Rows) { Sql8rDatabase db = createDb(ConnectionString, drDatabase); s.Databases.Add(db); } } log.Debug("Exit GetServer"); return(s); }
public Query GetProcedureQuery(Sql8rServer server, Sql8rDatabase database, Sql8rProcedure procedure) { string sqlProcedureHeader = string.Empty; string sqlProcedureBody = string.Empty; var myConnection = new MySqlConnection(); myConnection.ConnectionString = String.Format( "{0};database={1}", ConnectionString, database.Name); MySqlDataReader myReader = null; string sql = ResourceReader.GetResourceSql("SQL8r.Logic.MySQL.Queries.UI.EditProcedure.sql"); string dbSQL = string.Format(sql, procedure.Name); try { myConnection.Open(); var myCommand = new MySqlCommand(); myCommand.CommandText = dbSQL; myCommand.CommandType = CommandType.Text; myCommand.Connection = myConnection; myReader = myCommand.ExecuteReader(); if (myReader.Read()) { sqlProcedureBody = myReader.GetString(2); } } finally { myReader.Close(); myConnection.Close(); } string viewSql = string.Format("{0}{1}{2}", sqlProcedureHeader, Environment.NewLine, sqlProcedureBody); var q = new Query(_settings, server.Name, database.Name, viewSql); return(q); }
public Query GetProcedureQuery(Sql8rServer server, Sql8rDatabase database, Sql8rProcedure procedure) { string sql = ResourceReader.GetResourceSql("SQL8r.Logic.SqlServer.Queries.UI.EditProcedure.sql"); string dbSQL = string.Format(sql, database.Name, procedure.ObjectId); var dtTables = new DataTable("Tables") { Locale = CultureInfo.InvariantCulture }; var sdaTables = new SqlDataAdapter(dbSQL, ConnectionString); sdaTables.Fill(dtTables); DataRow drDatabase = dtTables.Rows[0]; string def = drDatabase["definition"].ToString(); var query = new Query(_settings, server.Name, database.Name, def); return(query); }
public void GetServerOtherStuff(Sql8rDatabase db) { string aSQL = string.Format(sqlAssemblies, db.Name); var dsAssemblies = new DataSet("Assemblies"); var sdaAssemblies = new SqlDataAdapter(aSQL, ConnectionString); sdaAssemblies.Fill(dsAssemblies); db.Assemblies.Clear(); foreach (DataRow drAssembly in dsAssemblies.Tables[0].Rows) { Sql8rAssembly a = addAssembly(drAssembly); DataRow[] types = dsAssemblies.Tables[1].Select(string.Format("assemblyId={0}", a.ObjectId)); foreach (DataRow drType in types) { Sql8rAssemblyType type = addAssembyType(drType); a.Types.Add(type.Name, type); } db.Assemblies.Add(a.Name, a); } }
private IList <SearchHit> checkForHit(Sql8rServer s, Sql8rDatabase db, bool isSystemObject, string objectType, IColumnedObject o, string criteria, bool exactMatch, bool caseSensitive) { IList <SearchHit> hits = new List <SearchHit>(); StringComparison cases = StringComparison.OrdinalIgnoreCase; if (caseSensitive) { cases = StringComparison.Ordinal; } foreach (Sql8rColumn c in o.Columns.Values) { bool IsMatch = false; if (exactMatch) { if (c.Name.Equals(criteria, cases)) { IsMatch = true; } } else { if (c.Name.IndexOf(criteria, cases) >= 0) { IsMatch = true; } } if (IsMatch) { var hit = new SearchHit(s.Name, db.Name, isSystemObject, objectType, o.Schema, o.Name, c.Name); hits.Add(hit); } } return(hits); }
public void ShowObject(Sql8rDatabase db) { _view.pgGeneric.SelectedObject = db; }
public Sql8rServer GetServer() { var myConnection = new OracleConnection(); myConnection.ConnectionString = @"USER ID=hr;PASSWORD=hr;DATA SOURCE=//localhost/xe"; //_settings.GetConnectionString(); var s = new Sql8rServer(_settings); OracleDataReader myReader = null; var db = new Sql8rDatabase("OracleTest", 0); try { myConnection.Open(); var myCommand = new OracleCommand(); myCommand.CommandText = "SELECT table_name, owner FROM all_tables"; myCommand.CommandType = CommandType.Text; myCommand.Connection = myConnection; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { var t = new Sql8rTable(myReader.GetString(0), "", myReader.GetString(1) == "SYSTEM" || myReader.GetString(1) == "SYS", 0); db.Tables.Add(t); var myColumnConnection = new OracleConnection(); //myColumnConnection.ConnectionString = _settings.GetConnectionString(); myColumnConnection.ConnectionString = @"USER ID=hr;PASSWORD=hr;DATA SOURCE=//localhost/xe"; OracleDataReader myColumnReader = null; try { myColumnConnection.Open(); var myColumnCommand = new OracleCommand(); myColumnCommand.CommandText = string.Format(CultureInfo.InvariantCulture, "SELECT column_name FROM user_tab_cols WHERE table_name = '{0}'", t.Name); myColumnCommand.CommandType = CommandType.Text; myColumnCommand.Connection = myColumnConnection; myColumnReader = myColumnCommand.ExecuteReader(); while (myColumnReader.Read()) { var c = new Sql8rColumn(myColumnReader.GetString(0), false, "", 0, 0); t.Columns.Add(c.ObjectId, c); } } finally { myColumnReader.Close(); myColumnConnection.Close(); } } myReader.Close(); myCommand.CommandText = "SELECT view_name, owner FROM all_views"; myCommand.CommandType = CommandType.Text; myCommand.Connection = myConnection; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { var v = new Sql8rView(myReader.GetString(0), "", myReader.GetString(1) == "SYSTEM" || myReader.GetString(1) == "SYS", 0); db.Views.Add(v); } myReader.Close(); myCommand.CommandText = "SELECT UNIQUE(object_name) FROM all_procedures"; myCommand.CommandType = CommandType.Text; myCommand.Connection = myConnection; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { var sp = new Sql8rProcedure(myReader.GetString(0), "", false, 0); db.Procedures.Add(sp.Name, sp); } myReader.Close(); s.Databases.Add(db); } finally { myConnection.Close(); } return(s); }
public Query GetAddIndexQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table) { throw new NotImplementedException(); }
public Query GetAlterColumnQuery(Sql8rServer server, Sql8rDatabase database, Sql8rTable table, Sql8rColumn column) { throw new NotImplementedException(); }