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)
{
}
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)
{
}