public static SqlTable AddDescription(this SqlTable table, string description)
{
var sqlTableDescription = new SqlTableDescription(table, description);
table.Properties.Add(sqlTableDescription);
return(table);
}
public void AddTableDocumentation(DatabaseDefinition dd)
{
var reader = Executer.ExecuteQuery(@"
SELECT
SCHEMA_NAME(t.schema_id) as SchemaName,
t.name AS TableName,
p.value AS Property
FROM
sys.tables AS t
INNER JOIN sys.extended_properties AS p ON p.major_id = t.object_id AND p.minor_id = 0 AND p.class = 1
AND p.name = 'MS_Description'");
var tables = dd.GetTables();
foreach (var row in reader.Rows)
{
// TODO SchemaAndTableName.Schema might be null on default schema?
var table = tables.Find(t => t.SchemaAndTableName.Schema == row.GetAs <string>("SchemaName") && t.SchemaAndTableName.TableName == row.GetAs <string>("TableName"));
if (table != null)
{
var description = row.GetAs <string>("Property");
if (!string.IsNullOrEmpty(description))
{
description = description.Replace("\\n", "\n", StringComparison.OrdinalIgnoreCase).Trim();
var descriptionProperty = new SqlTableDescription(table, description);
table.Properties.Add(descriptionProperty);
}
}
}
}
public void AddTableDocumentation(SqlTable table)
{
var reader = Executer.ExecuteQuery(new SqlStatementWithParameters(
SqlGetTableDocumentation + " AND SCHEMA_NAME(t.schema_id) = @SchemaName AND t.name = @TableName", table.SchemaAndTableName.Schema, table.SchemaAndTableName.TableName));
foreach (var row in reader.Rows)
{
var description = row.GetAs <string>("Property");
if (!string.IsNullOrEmpty(description))
{
description = description.Replace("\\n", "\n", StringComparison.OrdinalIgnoreCase).Trim();
var descriptionProperty = new SqlTableDescription(table, description);
table.Properties.Add(descriptionProperty);
}
}
}
