internal static IEnumerable <SchemaDataSet.ColumnsRow> GetColumnsForTable(string schema, string tableName, AuditUpdateParameters updateParameters) { SchemaDataSet schemaDataSet = updateParameters.SchemaDataSet; SchemaDataSet.ColumnsDataTable columnsDataTable = schemaDataSet.Columns; IEnumerable <SchemaDataSet.ColumnsRow> columnsRows = columnsDataTable.Rows.Cast <SchemaDataSet.ColumnsRow>(); IEnumerable <SchemaDataSet.ColumnsRow> query = from columnRow in columnsRows where columnRow.TABLE_SCHEMA.Equals(schema, StringComparison.OrdinalIgnoreCase) && columnRow.TABLE_NAME.Equals(tableName, StringComparison.OrdinalIgnoreCase) orderby columnRow.ORDINAL_POSITION select columnRow; return(query); }
internal static string DataTypeWithDetail(SchemaDataSet.SchemaPrimaryKeysRow primaryKeysRow, SchemaDataSet.ColumnsDataTable columnsDataTable) { var enumerableColumnsDataTable = columnsDataTable.AsEnumerable(); var columnsTableQuery = from columnsRow in enumerableColumnsDataTable where columnsRow.TABLE_SCHEMA.Equals(primaryKeysRow.TABLE_SCHEMA, StringComparison.OrdinalIgnoreCase) where columnsRow.TABLE_NAME.Equals(primaryKeysRow.TABLE_NAME, StringComparison.OrdinalIgnoreCase) where columnsRow.COLUMN_NAME.Equals(primaryKeysRow.COLUMN_NAME, StringComparison.OrdinalIgnoreCase) select columnsRow; var primaryKeyColumnRow = columnsTableQuery.FirstOrDefault(); if (null == primaryKeyColumnRow) { throw new InvalidOperationException("Unexpected: Did not find column from primary key table"); } return(string.Format("[{0}]{1}", primaryKeyColumnRow.DATA_TYPE.ToUpperInvariant(), DataTypeDetail(primaryKeyColumnRow))); }