/// <summary>
/// 添加扩展属性
/// </summary>
/// <param name="dbName"></param>
/// <param name="prop"></param>
public void Add(string dbName, Model.ExtendProp prop)
{
SqlParameter[] parms =
{
new SqlParameter("@name", SqlDbType.NVarChar, 128)
{
Value = prop.Name
},
new SqlParameter("@value", SqlDbType.Variant)
{
Value = prop.Value
},
new SqlParameter("@level0type", SqlDbType.NVarChar, 128)
{
Value = prop.SchemaType
},
new SqlParameter("@level0name", SqlDbType.NVarChar, 128)
{
Value = prop.SchemaName
},
new SqlParameter("@level1type", SqlDbType.NVarChar, 128)
{
Value = prop.TableType
},
new SqlParameter("@level1name", SqlDbType.NVarChar, 128)
{
Value = prop.TableName
},
new SqlParameter("@level2type", SqlDbType.NVarChar, 128)
{
Value = prop.ColumnType
},
new SqlParameter("@level2name", SqlDbType.NVarChar, 128)
{
Value = prop.ColumnName
},
};
ExecNonQuerySql(CommandType.StoredProcedure, "sys.sp_addextendedproperty", parms);
}
/// <summary>
/// 扩展属性是否存在
/// </summary>
/// <param name="dbName"></param>
/// <param name="prop"></param>
/// <returns></returns>
public bool Exist(string dbName, Model.ExtendProp prop)
{
return(false);
}
