public DatabaseInfo CreateDatabaseInfo()
{
DatabaseInfo database = new DatabaseInfo();
using (helper = new SqlServerHelper(Connect))
{
string sql = "select name from sysobjects where xtype='u' order by name;";
DataTable nameTable = helper.GetDataTable(sql);
for (int i = 0; i < nameTable.Rows.Count; ++i)
{
database.AddTable(CreateTable(nameTable.Rows[i][0].ToString()));
}
}
return(database);
}
public DatabaseInfo CreateDatabaseInfo()
{
DatabaseInfo database = new DatabaseInfo();
using (helper = new PostgreSqlHelper(Connect))
{
string sql = @"SELECT tablename FROM pg_tables
WHERE tablename NOT LIKE 'pg%'
AND tablename NOT LIKE 'sql_%'
ORDER BY tablename;";
DataTable nameTable = helper.GetDataTable(sql);
for (int i = 0; i < nameTable.Rows.Count; ++i)
{
database.AddTable(CreateTable(nameTable.Rows[i][0].ToString()));
}
}
return(database);
}