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+"";
}
第二步、修改如下
}
var simpleProperties = typeMapper.GetSimpleProperties(entity);
if (simpleProperties.Any())
{
foreach (var edmProperty in simpleProperties)
{
//实体属性开始
#>
///
///
///
//实体属性结束
}
}
if (complexProperties.Any())
{
#>
第三步:保存模板,就可以看到实体字段注释