Skip to content

Instantly share code, notes, and snippets.

@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