ef mysql注释_EF6 根据数据库字段说明，生成字段注释

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())

{

#>

第三步：保存模板，就可以看到实体字段注释