數據庫~大叔通過腳本生成poco實體 - lori－IT工程師數位筆記本

文章出處

今天在做開發時，需要把表映射成實體，又沒有EF這種工具，就從網上下了一個工具，但使用時覺得太重了，所以就自己寫了一個，基于mysql的。

功能：輸入表名，得到這個表的poco實體

SELECT
    COLUMN_TYPE,
    CONCAT(
        'public ',
        CASE
    WHEN LEFT (COLUMN_TYPE, 3) = 'int' THEN
        'int'
    WHEN LEFT (COLUMN_TYPE, 7) = 'tinyint' THEN
        'byte'
    WHEN LEFT (COLUMN_TYPE, 8) = 'smallint' THEN
        'short'
    WHEN LEFT (COLUMN_TYPE, 6) = 'bigint' THEN
        'long'
    WHEN LEFT (COLUMN_TYPE, 5) = 'float' THEN
        'float'
    WHEN LEFT (COLUMN_TYPE, 5) = 'double' THEN
        'double'
    WHEN LEFT (COLUMN_TYPE, 7) = 'decimal' THEN
        'decimal'
    WHEN LEFT (COLUMN_TYPE, 4) = 'char' THEN
        'string'
    WHEN LEFT (COLUMN_TYPE, 7) = 'varchar' THEN
        'string'
    WHEN LEFT (COLUMN_TYPE, 4) = 'text' THEN
        'string'
    WHEN LEFT (COLUMN_TYPE, 8) = 'datetime' THEN
        'DateTime'
    WHEN LEFT (COLUMN_TYPE, 4) = 'time' THEN
        'DateTime'
    WHEN LEFT (COLUMN_TYPE, 4) = 'date' THEN
        'DateTime'
    ELSE
        COLUMN_TYPE
    END,
    ' ',
    COLUMN_NAME,
    '{get;set;}'
    )
FROM
    information_schema. COLUMNS
WHERE
    table_name = 'business_datelist'
AND table_schema = 'pilipadb';