public List <ClassicleObject> GetTablesAndViews() { var cObjects = new List <ClassicleObject>(); 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 cObject = new ClassicleObject { ObjectName = (string)row["TABLE_NAME"] }; if (cObject.ObjectName.ToLower() == "dtproperties" || cObject.ObjectName.ToLower() == "syscolumns" || cObject.ObjectName.ToLower() == "sysdepends" || cObject.ObjectName.ToLower() == "syscomments" || cObject.ObjectName.ToLower() == "sysfilegroups" || cObject.ObjectName.ToLower() == "sysfiles" || cObject.ObjectName.ToLower() == "sysfiles1" || cObject.ObjectName.ToLower() == "sysforeignkeys" || cObject.ObjectName.ToLower() == "sysproperties" || cObject.ObjectName.ToLower() == "sysusers" || cObject.ObjectName.ToLower() == "sysconstraints" || cObject.ObjectName.ToLower() == "syssegments" || cObject.ObjectName.ToLower() == "sysdiagrams") { continue; } cObject.IsView = ((string)row["TABLE_TYPE"]).ToLower() == "view"; cObjects.Add(cObject); } } } } } } return(cObjects); }
public List <ClassicleObject> GetTablesAndViews() { var classicleObjects = new List <ClassicleObject>(); 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 ClassicleObject(); obj.IsView = false; obj.ObjectName = (string)row["TABLE_NAME"]; classicleObjects.Add(obj); } } using (DataTable views = connection.GetSchema("Views")) { foreach (DataRow row in views.Rows) { if (((string)row["TABLE_SCHEMA"]) != DatabaseName) { continue; } var obj = new ClassicleObject { IsView = true, ObjectName = (string)row["TABLE_NAME"] }; classicleObjects.Add(obj); } } } return(classicleObjects); }
public List<ClassicleObject> GetTablesAndViews() { var classicleObjects = new List<ClassicleObject>(); using (var connection = new SQLiteConnection(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 ClassicleObject { IsView = false, ObjectName = (string)row["TABLE_NAME"] }; classicleObjects.Add(obj); } } using (DataTable views = connection.GetSchema("Views")) { foreach (DataRow row in views.Rows) { var obj = new ClassicleObject { IsView = true, ObjectName = (string)row["TABLE_NAME"] }; classicleObjects.Add(obj); } } } return classicleObjects; }