通过SqlServer脚本生成C#模型

数据库

将表名和数据库名替换即可生成对应的C#模型

1. 先按CTRL+T(将结果展示为文本);
2. 再执行下面的Sql脚本;
3. 如果要转换到最初的以网格显示结果则直接按CTRL+D即可;

SELECT
    ('public ' + 
    CASE
        WHEN LEFT (DATA_TYPE, 3) = 'int' THEN
            'int'
        WHEN LEFT (DATA_TYPE, 7) = 'tinyint' THEN
            'byte'
        WHEN LEFT (DATA_TYPE, 8) = 'smallint' THEN
            'short'
        WHEN LEFT (DATA_TYPE, 6) = 'bigint' THEN
            'long'
        WHEN LEFT (DATA_TYPE, 5) = 'float' THEN
            'float'
        WHEN LEFT (DATA_TYPE, 5) = 'double' THEN
            'double'
        WHEN LEFT (DATA_TYPE, 7) = 'decimal' THEN
            'decimal'
        WHEN LEFT (DATA_TYPE, 7) = 'money' THEN
            'decimal'
        WHEN LEFT (DATA_TYPE, 4) = 'char' THEN
            'string'
        WHEN LEFT (DATA_TYPE, 7) = 'varchar' THEN
            'string'
        WHEN LEFT (DATA_TYPE, 8) = 'nvarchar' THEN
            'string'
        WHEN LEFT (DATA_TYPE, 4) = 'text' THEN
            'string'
        WHEN LEFT (DATA_TYPE, 8) = 'datetime' THEN
            'DateTime'
        WHEN LEFT (DATA_TYPE, 4) = 'time' THEN
            'DateTime'
        WHEN LEFT (DATA_TYPE, 4) = 'date' THEN
            'DateTime'
        ELSE
            DATA_TYPE
    END+
    CASE
        WHEN LEFT (IS_NULLABLE,3) = 'YES' AND DATA_TYPE NOT IN('char','varchar','nvarchar','text') THEN
            '?'
        ELSE
            ''
    END +
    ' ' +
    COLUMN_NAME +
    ' { get; set; }') AS xuxuzhaozhao  
FROM
    information_schema. COLUMNS
WHERE
    TABLE_NAME = '表名'
AND TABLE_CATALOG = '数据库名';