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)));
}
