protected TableSchemaExtend GetViewSchemaFromRow(DataRow row) { TableSchemaExtend schema = new TableSchemaExtend { Name = row[TableOfName] as String }; return(schema); }
protected TableSchemaExtend GetTableSchemaFromRow(DataRow row) { TableSchemaExtend schema = new TableSchemaExtend { Explain = row[TableOfComment] as String, Name = row[TableOfName] as String, }; return(schema); }
public IList <TableSchemaExtend> LoadViewSchemaList() { List <TableSchemaExtend> viewSchemas = new List <TableSchemaExtend>(); DataTable info = this._connection.GetSchema("Views", new String[] { null, this.GetDataBaseName(), null, null }); if (info.Rows.Count > 0) { foreach (DataRow row in info.Rows) { TableSchemaExtend schema = this.GetViewSchemaFromRow(row); viewSchemas.Add(schema); } } return(viewSchemas); }
public IList <TableSchemaExtend> LoadTableSchemaList() { List <TableSchemaExtend> tableSchemas = new List <TableSchemaExtend>(); DataTable info = this.ExecuteQuery(SQLForTableSchema); if (info.Rows.Count > 0) { foreach (DataRow row in info.Rows) { TableSchemaExtend schema = this.GetTableSchemaFromRow(row); tableSchemas.Add(schema); } } return(tableSchemas); }
public IList <TableSchemaExtend> LoadTableSchemaList() { List <TableSchemaExtend> tableSchemas = new List <TableSchemaExtend>(); String dataBase = this.GetDataBaseName(); DataTable info = this._connection.GetSchema(CollectionNameOfTable, new String[] { null, dataBase, null, null }); if (info.Rows.Count > 0) { foreach (DataRow row in info.Rows) { TableSchemaExtend schema = this.GetTableSchemaFromRow(row); tableSchemas.Add(schema); } } return(tableSchemas); }
public (Boolean success, TableSchemaExtend view, IList <ColumnSchemaExtend> columns) GetViewSchemaTuple(String viewName) { Boolean success = false; TableSchemaExtend viewSchema = null; IList <ColumnSchemaExtend> columnSchemas = null; if (String.IsNullOrEmpty(viewName)) { throw new ArgumentException(nameof(viewName)); } DataTable info = this._connection.GetSchema("Views", new String[] { null, this.GetDataBaseName(), viewName, null }); if (info.Rows.Count > 0) { var row = info.Rows[0]; viewSchema = this.GetTableSchemaFromRow(row); columnSchemas = this.LoadViewColumnSchemaList(viewName); success = true; } return(success, viewSchema, columnSchemas); }
public (Boolean success, TableSchemaExtend table, IList <ColumnSchemaExtend> columns) GetTableSchemaTuple(String tableName) { Boolean success = false; TableSchemaExtend tableSchema = null; IList <ColumnSchemaExtend> columnSchemas = null; if (String.IsNullOrEmpty(tableName)) { throw new ArgumentException(nameof(tableName)); } String tableSchemaSQL = String.Format(SQLForColumnSchemaWithWhere, tableName); DataTable info = this.ExecuteQuery(tableSchemaSQL); if (info.Rows.Count > 0) { var row = info.Rows[0]; tableSchema = this.GetTableSchemaFromRow(row); columnSchemas = this.LoadColumnSchemaList(tableName); success = true; } return(success, tableSchema, columnSchemas); }
public (Boolean success, TableSchemaExtend table, IList <ColumnSchemaExtend> columns) GetTableSchemaTuple(String tableName) { Boolean success = false; TableSchemaExtend tableSchema = null; IList <ColumnSchemaExtend> columnSchemas = null; if (String.IsNullOrEmpty(tableName)) { throw new ArgumentException(nameof(tableName)); } String dataBase = this.GetDataBaseName(); DataTable info = this._connection.GetSchema(CollectionNameOfTable, new String[] { null, dataBase, tableName, null }); if (info.Rows.Count > 0) { var row = info.Rows[0]; tableSchema = this.GetTableSchemaFromRow(row); columnSchemas = this.LoadColumnSchemaList(tableName); success = true; } return(success, tableSchema, columnSchemas); }