Skip to content

Instantly share code, notes, and snippets.

@vishnoor
Forked from pdwetz/gist:5368441
Created November 23, 2015 13:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vishnoor/2d64e727a23d6b146761 to your computer and use it in GitHub Desktop.
Save vishnoor/2d64e727a23d6b146761 to your computer and use it in GitHub Desktop.
Outputs a POCO for a given MySql table. Based on http://stackoverflow.com/a/13918084/21865 with mild formatting changes and additional types added.
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 '}';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment