MySQL根據(jù)表生成實體類

SELECT CONCAT('/// <summary>\n',
'///',column_comment,'\n'
,'/// </summary>','
public ',
(
case LOWER(Data_type)
when 'varchar' then 'string'
when 'text' then 'string'
when 'tinyint' then 'bool'
when 'bit' then 'bool'
when 'bigint' then 'long'
when 'datetime' then 'DateTime'
ELSE Data_type END
),
IF(IS_NULLABLE='YES','?','')
,' ', COLUMN_NAME,' {get;set;}\n') property FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='YourDataBaseName' AND TABLE_NAME='YourTableName' ORDER BY ORDINAL_POSITION ASC;