declare @TableName sysname = 'TableName' declare @Result varchar(max) = 'public class ' + @TableName + '

{'

SELECT

@Result = @Result + '

public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; }

'

FROM

(

SELECT

REPLACE(col.name, ' ', '_') ColumnName,

column_id ColumnId,

CASE

typ.name

WHEN 'bigint' THEN 'long'

WHEN 'binary' THEN 'byte[]'

WHEN 'bit' THEN 'bool'

WHEN 'char' THEN 'string'

WHEN 'date' THEN 'DateTime'

WHEN 'datetime' THEN 'DateTime'

WHEN 'datetime2' THEN 'DateTime'

WHEN 'datetimeoffset' THEN 'DateTimeOffset'

WHEN 'decimal' THEN 'decimal'

WHEN 'float' THEN 'double'

WHEN 'image' THEN 'byte[]'

WHEN 'int' THEN 'int'

WHEN 'money' THEN 'decimal'

WHEN 'nchar' THEN 'string'

WHEN 'ntext' THEN 'string'

WHEN 'numeric' THEN 'decimal'

WHEN 'nvarchar' THEN 'string'

WHEN 'real' THEN 'float'

WHEN 'smalldatetime' THEN 'DateTime'

WHEN 'smallint' THEN 'short'

WHEN 'smallmoney' THEN 'decimal'

WHEN 'text' THEN 'string'

WHEN 'time' THEN 'TimeSpan'

WHEN 'timestamp' THEN 'long'

WHEN 'tinyint' THEN 'byte'

WHEN 'uniqueidentifier' THEN 'Guid'

WHEN 'varbinary' THEN 'byte[]'

WHEN 'varchar' THEN 'string'

ELSE 'UNKNOWN_' + typ.name

END ColumnType,

CASE

WHEN col.is_nullable = 1

AND typ.name IN (

'bigint',

'bit',

'date',

'datetime',

'datetime2',

'datetimeoffset',

'decimal',

'float',

'int',

'money',

'numeric',

'real',

'smalldatetime',

'smallint',

'smallmoney',

'time',

'tinyint',

'uniqueidentifier'

) THEN '?'

ELSE ''

END NullableSign

FROM

sys.columns col

JOIN sys.types typ ON col.system_type_id = typ.system_type_id

AND col.user_type_id = typ.user_type_id

WHERE

object_id = object_id(@TableName)

) t

ORDER BY

ColumnId

SET

@Result = @Result + '

}' print @Result