IOT 数据库增加字段及备注
<pre><code class="language-csharp"> public void InserTable()
{
lstParam = collection.GetDeviceParam();
var ssss = lstParam.Where(d => d.DeviceNO == 10);
StringBuilder sbs = new StringBuilder();
string tableNames = "IoT_SprayC2Spray";
foreach (var item in ssss)
{
string sql = $@"
ALTER TABLE {tableNames} ADD {item.AddrColumn} {item.AddrType} NULL
EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = N'{item.AddrName}' ,
@level0type = N'SCHEMA',@level0name = N'dbo', @level1type = N'TABLE',@level1name = N'{tableNames}',
@level2type = N'COLUMN',@level2name = N'{item.AddrColumn}'";
sbs.AppendLine(sql);
}
string contents = sbs.ToString();
return;
}</code></pre>