public static SqlColumn AddDescription(this SqlColumn column, string description)
{
var sqlColumnDescription = new SqlColumnDescription(column, description);
column.Properties.Add(sqlColumnDescription);
return(column);
}
public void GetColumnDocumentation(SqlTable table)
{
var defaultSchema = Executer.Generator.Context.Settings.SqlVersionSpecificSettings.GetAs <string>("DefaultSchema");
var schemaAndTableName = (table.SchemaAndTableName.Schema ?? defaultSchema) + "." + table.SchemaAndTableName.TableName;
var rows = QueryResult[schemaAndTableName];
foreach (var row in rows)
{
var columnName = row.GetAs <string>("ColumnName");
if (table.Columns.TryGetValue(columnName, out var column))
{
var description = row.GetAs <string>("Property");
if (!string.IsNullOrEmpty(description))
{
description = description.Replace("\\n", "\n", StringComparison.OrdinalIgnoreCase).Trim();
var descriptionProperty = new SqlColumnDescription(column, description);
column.Properties.Add(descriptionProperty);
}
}
}
}
