SQLServer根据表名创建三层架构的Model

--新建实体类
select 'public '+case  when b.name IN('bigint' , 'int' , 'tinyint') then 'int'
when b.name in('decimal','numeric','float','money','smallmoney') then 'decimal'
when b.name in('text','ntext','varchar','nvarchar','char','nchar')  then 'string' 
when b.name in('bit') then 'bool'
when b.name in('datetime') then 'DateTime'
else 'X???' end+' '+ a.name+' {get; set;}'
from syscolumns a
left join systypes b on a.xtype=b.xtype 
where b.name<>'sysname' and a.id=object_id('AppUser')
order by a.colid