public PgSqlTrigger(PgSqlTable table, DataRow schemaRow) : base(table) { this.table = table; this.schemaRow = schemaRow; this.Name = (string)schemaRow["TRIGGER_NAME"]; }
protected override void PopulateTables(DbObjectCollection <Table> tablesCollection) { var tables = this.Connection.GetSchema("Tables", new string[] { this.connection.Database, "public" }); foreach (DataRow row in tables.Rows) { var table = new PgSqlTable(this); table.Name = row["table_name"] as string; tablesCollection.Add(table); if (row["table_type"] as string == "VIEW") { table.SetView(true); } } }
protected override void PopulateTables(DbObjectCollection <Table> tablesCollection) { using (var tables = Connection.GetSchema("Tables", new[] { Connection.Database, "public" })) { foreach (DataRow row in tables.Rows) { var table = new PgSqlTable(this, (string)row["table_name"]); tablesCollection.Add(table); } } using (var views = Connection.GetSchema("Views", new[] { Connection.Database, "public" })) { foreach (DataRow row in views.Rows) { var table = new PgSqlTable(this, (string)row["table_name"], isView: true, isReadOnly: (string)row["is_updatable"] == "NO"); tablesCollection.Add(table); } } }
public PgSqlTrigger(PgSqlTable table, string name) : base(table) { this.table = table; Name = name; }