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