private List <LgObject> GetTablesAndViews() { var lgObjects = new List <LgObject>(); using (var connection = new OleDbConnection(ConnectionString)) { connection.Open(); using (DataTable tables = connection.GetSchema("Tables")) { foreach (DataRow row in tables.Rows.Cast <DataRow>().Where(row => ((string)row["TABLE_TYPE"]).ToLower() == "table")) { var obj = new LgObject { IsView = false, ObjectName = (string)row["TABLE_NAME"] }; lgObjects.Add(obj); } foreach (DataRow row in tables.Rows.Cast <DataRow>().Where(row => ((string)row["TABLE_TYPE"]).ToLower() == "view")) { var obj = new LgObject { IsView = true, ObjectName = (string)row["TABLE_NAME"] }; lgObjects.Add(obj); } } } return(lgObjects); }
private List <LgObject> GetTablesAndViews() { var lgObjects = new List <LgObject>(); using (var connection = new SqlConnection()) { connection.ConnectionString = ConnectionString; using (var command = new SqlCommand()) { command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "sp_tables"; command.Parameters.AddWithValue("@table_qualifier", DatabaseName); command.Parameters.AddWithValue("@table_owner", DefaultSchema); using (var adapter = new SqlDataAdapter()) { adapter.SelectCommand = command; using (var ds = new DataSet()) { adapter.Fill(ds); if (ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { var lgObject = new LgObject { ObjectName = (string)row["TABLE_NAME"] }; if (lgObject.ObjectName.ToLower() == "dtproperties" || lgObject.ObjectName.ToLower() == "syscolumns" || lgObject.ObjectName.ToLower() == "sysdepends" || lgObject.ObjectName.ToLower() == "syscomments" || lgObject.ObjectName.ToLower() == "sysfilegroups" || lgObject.ObjectName.ToLower() == "sysfiles" || lgObject.ObjectName.ToLower() == "sysfiles1" || lgObject.ObjectName.ToLower() == "sysforeignkeys" || lgObject.ObjectName.ToLower() == "sysproperties" || lgObject.ObjectName.ToLower() == "sysusers" || lgObject.ObjectName.ToLower() == "sysconstraints" || lgObject.ObjectName.ToLower() == "syssegments" || lgObject.ObjectName.ToLower() == "sysdiagrams") { continue; } lgObject.IsView = ((string)row["TABLE_TYPE"]).ToLower() == "view"; lgObjects.Add(lgObject); } } } } } } return(lgObjects); }
private List <LgObject> GetTablesAndViews() { var lgObjects = new List <LgObject>(); #if ORACLE using (var connection = new Oracle.ManagedDataAccess.Client.OracleConnection(ConnectionString)) { connection.Open(); using (DataTable tables = connection.GetSchema("Tables")) { foreach (DataRow row in tables.Rows.Cast <DataRow>()) { if (!string.Equals(((string)row["OWNER"]), DefaultSchema, StringComparison.CurrentCultureIgnoreCase)) { continue; } var obj = new LgObject { IsView = false, ObjectName = (string)row["TABLE_NAME"] }; lgObjects.Add(obj); } } using (DataTable views = connection.GetSchema("Views")) { foreach (DataRow row in views.Rows) { if (!string.Equals(((string)row["OWNER"]), DefaultSchema, StringComparison.CurrentCultureIgnoreCase)) { continue; } var obj = new LgObject { IsView = true, ObjectName = (string)row["VIEW_NAME"] }; lgObjects.Add(obj); } } } #endif return(lgObjects); }
private List <LgObject> GetTablesAndViews() { var lgObjects = new List <LgObject>(); using (var connection = new MySqlConnection(ConnectionString)) { connection.Open(); using (DataTable tables = connection.GetSchema("Tables")) { foreach (DataRow row in tables.Rows.Cast <DataRow>()) { if (((string)row["TABLE_SCHEMA"]) != DatabaseName) { continue; } var obj = new LgObject(); obj.IsView = false; obj.ObjectName = (string)row["TABLE_NAME"]; lgObjects.Add(obj); } } using (DataTable views = connection.GetSchema("Views")) { foreach (DataRow row in views.Rows) { if (((string)row["TABLE_SCHEMA"]) != DatabaseName) { continue; } var obj = new LgObject { IsView = true, ObjectName = (string)row["TABLE_NAME"] }; lgObjects.Add(obj); } } } return(lgObjects); }