SELECT  'public '+(
CASE when b.name='varchar' then 'string'  WHEN b.name='userdecimal' then 'decimal'  WHEN b.name='smallint' then 'int' 
WHEN b.name='nvarchar' then 'string'  WHEN b.name='datetime' then 'DateTime?'  WHEN b.name='uniqueidentifier' then 'string' 
 WHEN b.name='char' then 'string'   WHEN b.name='float' then 'double'   WHEN b.name='bigint' then 'Int64' 
WHEN b.name='tinyint' then 'int'  WHEN b.name='bit' then 'bool'   WHEN b.name='money' then 'decimal'   WHEN b.name='nchar' then 'string' 
ELSE b.name end )+' '+a.name+' {get;set;}'
from syscolumns a left join systypes b on a.xusertype=b.xusertype
where id=object_id('视图')