EF6.0实体类添加注释

版权声明:本文为博主原创文章,遵循 CC 4.0 by-sa 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/voodooer/article/details/52749515

第一步: 在Model.tt文件添加一个方法读取数据库中的字段说明

public string GetRemark(EdmProperty edmProperty){
		//System.Diagnostics.Debugger.Launch();
		var tableName = edmProperty.DeclaringType.Name;
		var colName=_code.Escape(edmProperty);
		//System.Diagnostics.Debugger.Break();
		string sql = string.Format(@"SELECT
字段说明=isnull(props.[value],'')
FROM syscolumns cols
inner join sysobjects objs on cols.id= objs.id and  objs.xtype='U' and  objs.name<>'dtproperties'
left join sys.extended_properties props on cols.id=props.major_id and cols.colid=props.minor_id
where  objs.name='{0}' and cols.name='{1}'",tableName,colName);
		string sqlcon = "Data Source=192.168.1.102;User ID=sa;Password=123456;Initial Catalog=DTTT";
		object remark=new object();
		using(System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(sqlcon)){
			conn.Open();
			System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql, conn);
			remark =cmd.ExecuteScalar();    
		}      
		
	return remark+"";
	}
第二步:修改如下

<#
    }

    var simpleProperties = typeMapper.GetSimpleProperties(entity);
    if (simpleProperties.Any())
    {
        foreach (var edmProperty in simpleProperties)
        {
		//实体属性开始
#>

	/// <summary>
	/// <#=codeStringGenerator.GetRemark(edmProperty)#>
	/// </summary>
    <#=codeStringGenerator.Property(edmProperty)#>

<#
		//实体属性结束
        }
    }

    if (complexProperties.Any())
    {
#>
保存自动支行T4文件,注释就出来了.





展开阅读全文

没有更多推荐了,返回首页