Csharp_class_properties_using_sql_server_table.sql

SELECT CASE WHEN DATA_TYPE  = 'bigint' THEN CONCAT('public long', IIF(IS_NULLABLE = 'YES', '? ', ' ') , COLUMN_NAME,' { set; get; }')
	    WHEN DATA_TYPE  = 'nvarchar' THEN  CONCAT('public string', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
	    WHEN DATA_TYPE  = 'int' THEN CONCAT('public int', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
 	    WHEN DATA_TYPE  = 'datetime' THEN CONCAT('public DateTime', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
	    WHEN DATA_TYPE  = 'datetime2' THEN CONCAT('public DateTime', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
	    WHEN DATA_TYPE  = 'bit' THEN CONCAT('public bool', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
	    WHEN DATA_TYPE  = 'smallint' THEN CONCAT('public Int16', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
	    WHEN DATA_TYPE  = 'date' THEN CONCAT('public DateTime', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
	    WHEN DATA_TYPE  = 'numeric' THEN CONCAT('public decimal', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
	    WHEN DATA_TYPE  = 'timestamp' THEN CONCAT('public DateTime', IIF(IS_NULLABLE = 'YES', '? ', ' '), COLUMN_NAME,' { set; get; }')
	END AS CSharpProperty
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'[table_name]'