SELECT
CONCAT(
'\n/// <summary>\r\n/// ',
COLUMN_COMMENT,
'\r\n/// </summary>\r\npublic ',
CASE
DATA_TYPE
WHEN 'bigint' THEN
'int'
WHEN 'tinyint' THEN
'int'
WHEN 'varchar' THEN
'string?'
WHEN 'varbinary' THEN
'string'
WHEN 'text' THEN
'string?'
WHEN 'char' THEN
'string'
WHEN 'datetime' THEN
'DateTime'
WHEN 'date' THEN
'DateTime'
WHEN 'bit' THEN
'bool'
WHEN 'decimal' THEN
'decimal' ELSE DATA_TYPE
END,
' ',
COLUMN_NAME,
' {get;set;}'
) AS Remarkss
FROM
information_schema.COLUMNS
WHERE TABLE_SCHEMA='new_channel_operation' and TABLE_NAME = 'store';
select TABLE_NAME from information_schema.`TABLES` where TABLE_SCHEMA='new_channel_operation'
activity
activityapplication
activityempower
customer
log