SELECT
CONCAT(
'/// <summary>\r\n/// ',
COLUMN_COMMENT,
'\r\n/// </summary>\r\npublic ',
CASE
DATA_TYPE
WHEN 'bigint' THEN
'int'
WHEN 'tinyint' THEN
'int'
WHEN 'varchar' THEN
'string'
WHEN 'varbinary' THEN
'string'
WHEN 'text' THEN
'string'
WHEN 'char' THEN
'string'
WHEN 'datetime' THEN
'DateTime'
WHEN 'bit' THEN
'bool'
WHEN 'decimal' THEN
'decimal' ELSE DATA_TYPE
END,
' ',
COLUMN_NAME,
' {get;set;}'
) AS Remark
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '数据库名称'
AND TABLE_NAME = '数据库表名称';
————————————————
版权声明:本文为CSDN博主「daomengzei」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/Daomengzei/article/details/120744952