public static Dictionary <string, TableEntity.Column> GetColumnsByTable(string tableName)
{
Dictionary <string, TableEntity.Column> columnsDictionary = new Dictionary <string, TableEntity.Column>();
System.Data.DataTable columnDataTable = OracleDocument.GetColumnsByTableName(tableName);
foreach (System.Data.DataRow dataRow in columnDataTable.Rows)
{
// a.table_name,a.column_name,a.data_type,a.data_length,a.NULLABLE,a.column_id,b.comments
TableEntity.Column column = new TableEntity.Column();
column.ColumnName = dataRow["column_name"].ToString().ToLower();
column.ColumnType = dataRow["data_type"].ToString();
column.ColumnLength = dataRow["data_length"].ToString();
column.NullAble = dataRow["nullable"].ToString();
column.DefaultValue = dataRow["data_default"].ToString();
column.Comments = dataRow["comments"].ToString();
columnsDictionary.Add(column.ColumnName, column);
}
return(columnsDictionary);
}
