Generate class properties from table

TableEntityProperties.sql

SELECT
    'public '
    + CASE
        WHEN c.DATA_TYPE IN ('bigint')                                                  THEN 'long'
        WHEN c.DATA_TYPE IN ('int')                                                     THEN 'int'
        WHEN c.DATA_TYPE IN ('smallint')                                                THEN 'short'
        WHEN c.DATA_TYPE IN ('tinyint')                                                 THEN 'byte'
        WHEN c.DATA_TYPE IN ('decimal', 'numeric', 'smallmoney', 'money')               THEN 'decimal'
        WHEN c.DATA_TYPE IN ('real')                                                    THEN 'single'
        WHEN c.DATA_TYPE IN ('float', 'decimal')                                        THEN 'double'
        WHEN c.DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'text', 'ntext')   THEN 'string'
        WHEN c.DATA_TYPE IN ('smalldatetime', 'datetime', 'datetime2', 'date')          THEN 'DateTime'
        WHEN c.DATA_TYPE IN ('time')                                                    THEN 'TimeSpan'
        WHEN c.DATA_TYPE IN ('datetimeoffset')                                          THEN 'DateTimeOffset'
        WHEN c.DATA_TYPE IN ('bit')                                                     THEN 'bool'
        WHEN c.DATA_TYPE IN ('uniqueidentifier')                                        THEN 'Guid'
        WHEN c.DATA_TYPE IN ('binary', 'varbinary', 'image', 'timestamp', 'rowversion') THEN 'byte[]'
        WHEN c.DATA_TYPE IN ('xml')                                                     THEN 'Xml'
    END
    + CASE
        WHEN c.IS_NULLABLE = 'YES' AND c.DATA_TYPE <> 'varchar' THEN '? '
        ELSE ' '
    END
    + c.COLUMN_NAME + ' { get; set; }' 
FROM information_schema.columns c
WHERE c.table_name = 'Premio'