根据MySQL表生成C#实体模型

USE INFORMATION_SCHEMA;
SELECT
    CONCAT(
        '/// <summary>\r\n/// ',
        COLUMN_COMMENT,
        '\r\n/// </summary>\r\n[DataMember]\r\npublic ',
    CASE
            DATA_TYPE
            WHEN 'bigint' THEN
            IF(IS_NULLABLE='YES','int?','int')
            WHEN 'tinyint' THEN
            IF(IS_NULLABLE='YES','int?','int')
            WHEN 'varchar' THEN
            'string'
            WHEN 'varbinary' THEN
            'string'
            WHEN 'text' THEN
            'string'
            WHEN 'char' THEN
            'string'
            WHEN 'datetime' THEN
             IF(IS_NULLABLE='YES','DateTime?','DateTime')
            WHEN 'bit' THEN
             IF(IS_NULLABLE='YES','bool?','bool')
            WHEN 'decimal' THEN
            IF(IS_NULLABLE='YES','decimal?','decimal')
                        ELSE DATA_TYPE
        END,
        ' ',
        COLUMN_NAME,
        ' {get;set;}\r\n'
)
FROM
COLUMNS
WHERE
    TABLE_SCHEMA = 'DBName'
    AND TABLE_NAME = 'TableName';