gistfile1.txt

select 'replacewithtablename' into @table;
select 'replacewithdatabasename' into @schema;

select concat('public class ',@table,'{')
union

select concat('public ',tps.dest,' ',column_name,'{get;set;}')
from information_schema.columns c
  join (
		select 'char' as orign ,'string' as dest union all
		select 'varchar' ,'string' union all
		select 'datetime' ,'DateTime' union all
		select 'date' ,'DateTime' union all
		select 'text' ,'string' union all
		select 'int' ,'int' union all
		select 'decimal' ,'decimal' union all
		select 'tinyint' ,'bool'
	) tps on c.data_type like tps.orign
where table_schema=@schema and table_name=@table union

select '}';