Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am aalee on github.
  • I am aalee (https://keybase.io/aalee) on keybase.
  • I have a public key ASC52tD1q0CD1FU7zb27tKeXU8lHSbf2k8-m8YxQ0s4L9Ao

To claim this, I am signing this object:

@aalee
aalee / Create C# Class from MySQL classes
Created June 20, 2018 03:26
This code create c# class of your Mysql table.
set @schema := 'schema_name';
set @table := 'table_name';
SET group_concat_max_len = 2048;
SELECT
concat('public class ', @table, '\n{\n', GROUP_CONCAT(a.property_ SEPARATOR '\n'), '\n}') class_
FROM
(select
CONCAT(
'\tpublic ',
case