A simple TSQL script to quickly generate c# POCO classes from SQL Server tables and views. You may tweak the output as needed. Not all datatypes are represented but this should save a bunch of boilerplate coding. USAGE: Run this query against the database of your choice. The script will loop through tables, views and their respective columns. Re…

TSQL-to-POCO

declare @tableName varchar(200)
declare @columnName varchar(200)
declare @nullable varchar(50)
declare @datatype varchar(50)
declare @maxlen int

declare @sType varchar(50)
declare @sProperty varchar(200)

DECLARE table_cursor CURSOR FOR 
SELECT TABLE_NAME
FROM [INFORMATION_SCHEMA].[TABLES]

OPEN table_cursor

FETCH NEXT FROM table_cursor 
INTO @tableName

WHILE @@FETCH_STATUS = 0
BEGIN

PRINT 'public class ' + @tableName + ' {'

    DECLARE column_cursor CURSOR FOR 
    SELECT COLUMN_NAME, IS_NULLABLE, DATA_TYPE, isnull(CHARACTER_MAXIMUM_LENGTH,'-1') 
  from [INFORMATION_SCHEMA].[COLUMNS] 
	WHERE [TABLE_NAME] = @tableName
	order by [ORDINAL_POSITION]

    OPEN column_cursor
    FETCH NEXT FROM column_cursor INTO @columnName, @nullable, @datatype, @maxlen

    WHILE @@FETCH_STATUS = 0
    BEGIN

	-- datatype
	select @sType = case @datatype
	when 'int' then 'Int32'
	when 'decimal' then 'Decimal'
	when 'money' then 'Decimal'
	when 'char' then 'String'
	when 'nchar' then 'String'
	when 'varchar' then 'String'
	when 'nvarchar' then 'String'
	when 'uniqueidentifier' then 'Guid'
	when 'datetime' then 'DateTime'
	when 'bit' then 'Boolean'
	else 'String'
	END

		If (@nullable = 'NO')
			PRINT '[Required]'
		if (@sType = 'String' and @maxLen <> '-1')
			Print '[MaxLength(' +  convert(varchar(4),@maxLen) + ')]'
		SELECT @sProperty = 'public ' + @sType + ' ' + @columnName + ' { get; set;}'
		PRINT @sProperty

		print ''
		FETCH NEXT FROM column_cursor INTO @columnName, @nullable, @datatype, @maxlen
	END
    CLOSE column_cursor
    DEALLOCATE column_cursor

	print '}'
	print ''
    FETCH NEXT FROM table_cursor 
    INTO @tableName
END
CLOSE table_cursor
DEALLOCATE table_cursor

Thanks a lot,
I added Float Double management plus KEY

alter procedure usp_generate @tableName_arg varchar(200)
as
/*
example
  exec usp_generate @tableName_arg = 'P_SECONDO'
*/
BEGIN
	set nocount on;

    declare @tableName varchar(200)
	declare @columnName varchar(200)
	declare @nullable varchar(50)
	declare @datatype varchar(50)
	declare @maxlen int

	declare @sType varchar(50)
	declare @sProperty varchar(200)
	declare @IsKey int;
	declare @col_ordinal int;


DECLARE table_cursor CURSOR FAST_FORWARD FOR 
	SELECT TABLE_NAME
	FROM [INFORMATION_SCHEMA].[TABLES] T
	where t.TABLE_TYPE = 'BASE TABLE'
	and not ( TABLE_NAME LIKE 'sys%' or TABLE_NAME LIKE 'MSMerg%'  OR TABLE_NAME LIKE 'MSRepl%' OR  TABLE_NAME LIKE 'MSDynam%'  )
	and TABLE_NAME = @tableName_arg
	order by TABLE_NAME asc;

OPEN table_cursor

FETCH NEXT FROM table_cursor 
INTO @tableName

WHILE @@FETCH_STATUS = 0
BEGIN

PRINT 'public class ' + @tableName + ' {'
PRINT '';
PRINT '    #region column_scaffolding';

PRINT '';


    DECLARE column_cursor CURSOR FAST_FORWARD FOR 
		with cte_pk as (
				SELECT Col.Column_Name  from 
				INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab, 
				INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col 
			WHERE 
				Col.Constraint_Name = Tab.Constraint_Name
				AND Col.Table_Name = Tab.Table_Name
				AND Tab.Constraint_Type = 'PRIMARY KEY'
				AND Col.Table_Name = @tableName
		)
			SELECT C.COLUMN_NAME, IS_NULLABLE, DATA_TYPE, isnull(CHARACTER_MAXIMUM_LENGTH,'-1') ,
			C.ORDINAL_POSITION, case when cte_pk.Column_Name is not null then 1 else 0 end as PK
			--, C.*
		  from [INFORMATION_SCHEMA].[COLUMNS] C
		  left outer join cte_pk
		  on C.COLUMN_NAME = cte_pk.Column_Name
			WHERE [TABLE_NAME] = @tableName
			order by C.[ORDINAL_POSITION];


    OPEN column_cursor
    FETCH NEXT FROM column_cursor INTO @columnName, @nullable, @datatype, @maxlen, @col_ordinal, @IsKey

    WHILE @@FETCH_STATUS = 0
    BEGIN

	-- datatype
	select @sType = case @datatype
	when 'int' then 'Int32'
	when 'decimal' then 'Decimal'
	when 'money' then 'Decimal'
	when 'char' then 'String'
	when 'nchar' then 'String'
	when 'varchar' then 'String'
	when 'nvarchar' then 'String'
	when 'uniqueidentifier' then 'Guid'
	when 'datetime' then 'DateTime'
	when 'bit' then 'Boolean'
	when 'float' then 'Double'
	else 'String'
	END

	    If (@IsKey = 1)
			PRINT '    [Key]';
		If (@nullable = 'NO')
			PRINT '    [Required]'
		    raiserror('    [Column(Order=%d)]',10,0,@col_ordinal);
		if (@sType = 'String' and @maxLen <> '-1')
			PRINT '    [MaxLength(' +  convert(varchar(4),@maxLen) + ')]'
		SELECT @sProperty = '    public ' + @sType + ' ' + @columnName + ' { get; set;}'
		PRINT @sProperty

		print ''
		FETCH NEXT FROM column_cursor INTO @columnName, @nullable, @datatype, @maxlen,  @col_ordinal, @IsKey
	END
    CLOSE column_cursor
    DEALLOCATE column_cursor

	PRINT '    #endregion';
	print ''
	print '}'
	print ''
    FETCH NEXT FROM table_cursor 
    INTO @tableName
END
CLOSE table_cursor
DEALLOCATE table_cursor;

END;

output example:

public class P_SECONDO {
 
    #region column_scaffolding
 
    [Key]
    [Required]
    [Column(Order=1)]
    public Int32 id { get; set;}
 
    [Column(Order=2)]
    [MaxLength(30)]
    public String desc1 { get; set;}
 
    [Required]
    [Column(Order=3)]
    public Guid rowguid { get; set;}
 
    [Column(Order=4)]
    public Decimal my_decimal { get; set;}
 
    [Column(Order=5)]
    public Double my_float { get; set;}
 
    #endregion
 
}
 

That's a very good observation you made. I missed seeing that double type is not there in the logic.