Database Table to Poco

gistfile1.sql

declare @tableName nvarchar(75)
Select @tableName = ''

select
      'public ' +
      case c.system_type_id
            when 127 then 'Int64'
            when 108 then 'decimal'
            when 56 then 'int'
            when 52 then 'int'
            when 175 then 'string'
            when 231 then 'string'
            when 167 then 'string'
            when 231 then 'string'
            when 61 then 'DateTime'
            when 104 then 'bool'
            else 'string'
      end + ' ' +
      c.[name] + ' ' +
      '{ get; set; }'
from
      sys.columns c
inner join
      sys.tables t on t.object_id = c.object_id
where
      t.name = @tableName