model classes design from query

 SELECT  COLUMN_NAME  + ':'+  CASE

WHEN DATA_TYPE = 'nvarchar' THEN 'string'

WHEN DATA_TYPE = 'int' THEN 'number'

WHEN DATA_TYPE = 'datetime' THEN 'Date'

WHEN DATA_TYPE = 'bit' THEN 'boolean'

ELSE DATA_TYPE

END

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = N'tablename'

SELECT 'public ' +CASE

WHEN DATA_TYPE = 'nvarchar' THEN 'string'

WHEN DATA_TYPE = 'datetime' THEN 'DateTime?'

WHEN DATA_TYPE = 'bit' THEN 'bool?'

ELSE DATA_TYPE

END

+ ' '+COLUMN_NAME + ' { get; set; }'

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = N'tablename'