Pinned

1. Generate c# clsss from DB table Generate c# clsss from DB table

   1

   declare @TableName sysname = 'TableName'

   2

   declare @Result varchar(max) = 'public class ' + @TableName + '

   3

   {'

   4

   5

   select @Result = @Result + '

2. mysql_generate.sql mysql_generate.sql

   1

   select concat('public ',tps.dest,' ',column_name,'{get;set;}') as code 

   2

   from  information_schema.columns c

   3

   join(

   4

   select 'char' as orign ,'string' as dest union all

   5

   select 'varchar' ,'string' union all

3. AdventOfCode2023 AdventOfCode2023 Public

   C#