EF6 Model.tt根据数据库字段说明，生成字段注释
1、第一步: 在Model.tt文件添加一个方法读取数据库中的字段说明
找到public string Property(EdmProperty edmProperty)这个方法，添加到这个方法下面
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.18;User ID=sa;Password=admin-tyt0820;Initial Catalog=SLIM"; 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+""; }
GarsonZhang www.yesdotnet.com
第二步、修改如下
<#
}
var simpleProperties = typeMapper.GetSimpleProperties(entity);
if (simpleProperties.Any())
{
foreach (var edmProperty in simpleProperties)
{
//实体属性开始
#>
/// <summary>
/// <#=codeStringGenerator.GetRemark(edmProperty)#>
/// </summary>
<#=codeStringGenerator.Property(edmProperty)#>
<#
//实体属性结束
}
}
if (complexProperties.Any())
{
#>
第三步：保存模板，就可以看到实体字段注释
来自 <https://www.cnblogs.com/mingjia/p/10505549.html>
版权声明：本文为YES开发框架网发布内容,转载请附上原文出处连接
post YES开发框架
