SQL Server 2012 upwards, stored procedure to write a C# class for a given table name

SqlTableToCSharp.sql

create procedure [utils].[SqlTableToCSharp]
	
	@tableName nvarchar(MAX)

as

begin

	declare @classBody nvarchar(MAX) = '';

	with tableColumns as (

		select schema_name(tab.schema_id) as schema_name,
			tab.name as table_name, 
			col.column_id,
			col.name as column_name, 
			t.name as data_type,    
			col.max_length,
			col.precision

		from
			sys.tables as tab
	
		inner join
			sys.columns as col
			on tab.object_id = col.object_id

		left join
			sys.types as t
			on col.user_type_id = t.user_type_id

	),

	propertyStrings as (

		select
			concat(
				'  public ',
				case data_type
					when 'int' then 'int'
					when 'varchar' then 'string'
					when 'nvarchar' then 'string'
					when 'char' then 
						case max_length
							when 1 then 'char'
							else 'string'
						end
					when 'numeric' then 'decimal'
					when 'float' then 'float'
					when 'datetime' then 'DateTime'
					when 'bit' then 'bool'
					when 'smallint' then 'short'
					else 'FIXMEDATATYPE'
				end,
				' ',
				column_name,
				' { get; set; }'
			) as propertyLine

		from
			tableColumns

		where
			table_name = @tableName

	)

	select
		@classBody = coalesce(@classBody + CHAR(13) + propertyLine, propertyLine)
		from propertyStrings;
	
	select 
		concat(
			'public class ',
			@tableName,
			CHAR(13),
			'{',
			@classBody,
			CHAR(13),
			'}'
		);
end

28th Oct 2020 - Updated data types to include short/bool and better detection for char(1) vs string