EF6.0实体类添加注释

来源：互联网发布：java最新版本编辑：程序博客网时间：2024/06/10 17:15

第一步: 在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 colsinner 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_idwhere  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文件,注释就出来了.

0 0