pdwetz

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