Thomas Weller thomasw-mitutoyo-ctl
thomasw-mitutoyo-ctl
/ gist:9dc43e0ec0d41af970d3a5c755c1cb74
Last active
April 26, 2018 14:53
— forked from pdwetz/gist:5368441
Outputs a POCO for a given MySql table. Based on http://stackoverflow.com/a/13918084/21865 with changes for ShaoLinq.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select 'replacewithtablename' into @table; | |
| select 'replacewithdatabasename' into @schema; | |
| select GROUP_CONCAT(r.x SEPARATOR '\n') from | |
| ( | |
| select '[DataAccessObject]'as x,'grp'as grp union | |
| select concat('public abstract class ',@table,'{') as x, 'grp' as grp | |
| union | |
| select concat('[PersistedMember]\npublic abstract ',tps.dest,IF(tps.dest = 'string', ' ', IF(is_nullable = 'NO', ' ', '? ')), REPLACE(column_name, ' ', ''),' {get;set;}'), 'grp' |
NewerOlder