public void AddSchemaToDatabase(SqlSchema oSchema) { if (oSchema != null) { ListSchema.Add(oSchema); } }
internal virtual void GetSchema() { var sb = new StringBuilder("USE [@dbname] SELECT DISTINCT table_schema FROM INFORMATION_SCHEMA.TABLES ORDER BY table_schema"); sb.Replace("@dbname", Name); using (var conn = _parent.GetConnection()) { using (var cmd = new SqlCommand(sb.ToString(), conn)) { try { conn.Open(); var rdr = cmd.ExecuteReader(); while (rdr.Read()) { var s = rdr.GetString(0); var oSchema = new SqlSchema(this, s); AddSchemaToDatabase(oSchema); } } finally { conn.Close(); } } } }
public SqlTable(SqlSchema parent, string name) { _parent = parent; Name = name; }
public SqlView(SqlSchema parent, string name) : base(parent, name) { }