SELECT CONCAT( '/// <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 'bit' THEN 'bool' WHEN 'decimal' THEN 'decimal' ELSE DATA_TYPE END, ' ', COLUMN_NAME, ' {get;set;}' ) AS Remark FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'DB数据库名称' AND TABLE_NAME = 'Table表名';
MySql 表 转为C#实体类 ,sql语句
最新推荐文章于 2022-05-25 11:55:16 发布