public List <DBObject> GetSchemaViews(IDataStore dstore)
{
List <DBObject> toReturn = new List <DBObject>();
OracleCommand getColumns = new OracleCommand();
OracleCommand getTables = new OracleCommand();
getTables.CommandText = _GetViews;
QueryData tables = dstore.ExecuteComamands.ExecuteCommandQuery(getTables, dstore.Connection);
for (int i = 0; i < tables.RowCount; i++)
{
DBObject t = new DBObject();
t.Name = tables.GetDataForRowField(0, i).ToString();
t.Columns = new List <Column>();
getColumns.CommandText = string.Format(_GetTableColumns, t.Name);
QueryData columns = dstore.ExecuteComamands.ExecuteCommandQuery(getColumns, dstore.Connection);
for (int j = 0; j < columns.RowCount; j++)
{
t.Columns.Add(new Column()
{
Name = columns.GetDataForRowField("column_name", j).ToString(),
DataType = columns.GetDataForRowField("data_type", j).ToString(),
IsPrimaryKey = false
});
}
toReturn.Add(t);
}
return(toReturn);
}
