自动生成实体类

开发中有手写实体很麻烦，于是用代码生成器生成，但是有时代码生成器生成的不是最新的实体表示方法！还是自己手写吧!

declare @tablename varchar(20) select @tablename = 'o_ems' -------------生成变量,使用表格形式(ctrl + D)输出，取第一个字段的值---------------------------------- select 'private '+ Case when t.name='varchar' Then 'string' when t.name='char' Then 'string' when t.name='datetime' Then 'datetime' when t.name='int ' Then 'int' when t.name='smallint' Then 'int' when t.name='money' Then 'float' when t.name='decimal' Then 'decimal' when t.name='tinyint' Then 'byte' else t.name end + ' _'+upper(substring(c.name,1,1))+lower(substring(c.name,2,(len(c.name)-1)))+';' as name /*,o.name,t.name,c.length,c.* ,isnull(m.text,'') */ from syscolumns c inner join sysobjects o on o.id=c.id inner join systypes t on c.xtype=t.xtype left outer join syscomments m on c.cdefault=m.id where o.name =@tablename order by c.id

以上是生成变量，

结果更改后生成实体

 

declare @tablename varchar(20) select @tablename = 'o_ems' -------------生成变量,使用表格形式(ctrl + D)输出，取第一个字段的值---------------------------------- select 'private '+ Case when t.name='varchar' Then 'string' when t.name='char' Then 'string' when t.name='datetime' Then 'datetime' when t.name='int ' Then 'int' when t.name='smallint' Then 'int' when t.name='money' Then 'float' when t.name='decimal' Then 'decimal' when t.name='tinyint' Then 'byte' else t.name end + ' '+c.name+'{ get; set; }' as name /*,o.name,t.name,c.length,c.* ,isnull(m.text,'') */ from syscolumns c inner join sysobjects o on o.id=c.id inner join systypes t on c.xtype=t.xtype left outer join syscomments m on c.cdefault=m.id where o.name =@tablename order by c.id

 

 

但是以上还不是最好，因为没有注释！需要改进

 

 

以下是如何获取表的属性的代码

declare @table_name as varchar(max) set @table_name = 'o_ems' select sys.columns.name, sys.types.name, sys.columns.max_length, sys.columns.is_nullable, (select count(*) from sys.identity_columns where sys.identity_columns.object_id = sys.columns.object_id and sys.columns.column_id = sys.identity_columns.column_id) as is_identity , (select value from sys.extended_properties where sys.extended_properties.major_id = sys.columns.object_id and sys.extended_properties.minor_id = sys.columns.column_id) as description from sys.columns, sys.tables, sys.types where sys.columns.object_id = sys.tables.object_id and sys.columns.system_type_id=sys.types.system_type_id and sys.tables.name=@table_name order by sys.columns.column_id