SQL自动生成实体类

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
 
 
-------------生成方法，使用文本形式(ctrl + T)输出----------------------------------
select '/// <summary>' +char(13)+char(10)+'///'+char(13)+char(10)+'/// <summary>'+char(13)+char(10)
+ 'public '+ 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)))+char(13)+char(10)
+ '{' +char(13)