MySQL C# 实体生成 语句

TableName 要生成的表名 

DBName 表所在库的名称 //加这个的原因是怕不同库中有相同的表名

 
SET @DBName='BaseDatabase';
    SET @TableName='UserInfo';
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 = @DBName
    AND TABLE_NAME = @TableName;