脚本生成SQL Server表的POCO对象

脚本生成SQL Server表的POCO对象

偶然在网上看到下面这个法子。

代码：

SELECT
    DATA_TYPE,
    CONCAT('public ',
    CASE
        WHEN DATA_TYPE = 'int' THEN 'int'
        WHEN DATA_TYPE = 'tinyint' THEN 'byte'
        WHEN DATA_TYPE = 'smallint' THEN 'short'
        WHEN DATA_TYPE = 'bigint' THEN 'long'
        WHEN DATA_TYPE = 'float' THEN 'float'
        WHEN DATA_TYPE = 'double' THEN 'double'
        WHEN DATA_TYPE = 'decimal' THEN 'decimal'
        WHEN DATA_TYPE = 'char' THEN 'string'
        WHEN DATA_TYPE = 'varchar' THEN 'string'
        WHEN DATA_TYPE = 'nvarchar' THEN 'string'
        WHEN DATA_TYPE = 'text' THEN 'string'
        WHEN DATA_TYPE = 'datetime' THEN 'DateTime'
        WHEN DATA_TYPE = 'time' THEN 'DateTime'
        WHEN DATA_TYPE = 'date' THEN 'DateTime'
        WHEN DATA_TYPE = 'uniqueidentifier' THEN 'Guid'
        ELSE
            DATA_TYPE
    END,
    ' ',
    COLUMN_NAME,
    ' { get; set; }'
    )
FROM
    information_schema.COLUMNS
WHERE
    table_schema = 'dbo' and table_name = 'your table name'

说明：
利用SQL Serve的信息架构视图直接生成属性列表，copy到类中即可。