Outputs a POCO for a given MySql table. Based on http://stackoverflow.com/a/13918084/21865 with mild formatting changes and additional types added.

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 'binary' ,'byte[]' union all
		select 'int' ,'int' union all
		select 'decimal' ,'decimal' union all
		select 'float' ,'float' union all
		select 'tinyint' ,'bool'
	) tps on c.data_type like tps.orign
where table_schema=@schema and table_name=@table union

select '}';

Sheer brilliance. Thanks to both you and MeelStorm for this :)

I added The following line to manage binary fields such as md5/sha hashes etc.

select 'binary' ,'byte[]' union all

please add select 'float' ,'float' union all for float datatype

Timestamp datatype is missing.
Please add select 'timestamp' ,'DateTime' union all

I have written a bash script to make your life easier. It was in the comments area on https://gist.github.com/shukebeta/b315c940f63277fa982e6c93c0f97040